Stack Overflow
Stack Overflow

Questions tagged [heroku-postgres]

Heroku Postgres is the SQL database service run by Heroku that is provisioned and managed as an add-on.

Heroku Postgres is the SQL database service run by Heroku that is provisioned and managed as an add-on. Heroku Postgres is accessible from any language with a PostgreSQL driver including all languages and frameworks supported by Heroku: Java, Ruby, Python, Scala, Play, Node.js and Clojure.

In addition to a variety of management commands available via the Heroku CLI, Heroku Postgres features a web dashboard, the ability to create dataclips and several additional services on top of a fully managed database service.

Useful Links

Heroku Postgres introduction
Heroku Postgres Technical Characterization
Efficient Indexing with Heroku Postgres
Choosing the Right Heroku Postgres Plan

1052 questions
53
votes
1 answer

Upgrade hobby-dev to hobby-basic on Heroku

I'm still getting my head wrapped around Heroku's plans. But I know I'm going to have around 3M rows in the db so I need to upgrade from hobby-dev to hobby-basic. However, I can't find any documentation or help about this level of upgrade. Only docs…
brianrhea
  • 3,674
  • 3
  • 34
  • 57
51
votes
9 answers

Heroku Database Connection Properties

I'm trying to perform a relatively trivial task: I want to connect to a Heroku database. I have created the database and have been issued credentials from the Heroku site. However, when I try to connect to this database using anything besides the…
meoww-
  • 1,892
  • 2
  • 21
  • 29
45
votes
13 answers

Getting "Unknown primary key for table" while the ID is there

I've been debugging this strange problem of Rails giving me "Unknown primary key for table...", even when the table's ID is there. I've copied the database from one heroku app to another, on the original databse there is no problem and the new one…
hakunin
  • 4,041
  • 6
  • 40
  • 57
44
votes
9 answers

How to change DATABASE_URL for a heroku application

I wanted to use an external Database with my heroku application. But I'm unable to edit the configuration cariables. I tried using GUI, Which says, Cannot overwrite attachment values DATABASE_URL. While I tried using CLI as well. I used the command:…
Ninja Boy
  • 1,112
  • 3
  • 14
  • 28
44
votes
5 answers

How can I browse my Heroku database?

Now that I've deployed my webapp to Heroku, how would I be able to browse the database as it's altered over time?
Andrew
  • 3,839
  • 10
  • 29
  • 42
41
votes
5 answers

Heroku Review Apps: copy DB to review app

Trying to fully automate Heroku's Review Apps (beta) for an app. Heroku wants us to use db/seeds.rb to seed the recently spun up instance's DB. We don't have a db/seeds.rb with this app. We'd like to set up a script to copy the existing DB from the…
Meltemi
  • 37,979
  • 50
  • 195
  • 293
35
votes
7 answers

How can I download db from heroku?

I'm using heroku and I want to download the database from my app(heroku) so I can make some changes in it, I've installed pgbackups, but using heroku pgbackups:url downloads a .dump file How can I download a postgresql file or translate that .dump…
Sascuash
  • 3,661
  • 10
  • 46
  • 65
33
votes
8 answers

ERROR: extension "btree_gist" must be installed in schema "heroku_ext"

Heroku made a change to the way postgressql extensions gets installed This is screwing up new rails review apps in heroku with the following error. ERROR: extension "btree_gist" must be installed in schema "heroku_ext" This is screwing up things as…
Raghu Varma
  • 131
  • 3
  • 5
32
votes
10 answers

Pgadmin is not loading

i have recently installed pgadmin4 onto my laptop and when I launch the application, it just gets stuck on the loading. I had a look at the logs and this is what I see: The logs 2020-11-14 00:22:46: Checking for system tray... 2020-11-14 00:22:46:…
Yonis Mohamoud
  • 321
  • 1
  • 3
  • 3
31
votes
8 answers

Heroku postgres postgis - django releases fail with: relation "spatial_ref_sys" does not exist

Heroku changed their PostgreSQL extension schema management on 01 August 2022. (https://devcenter.heroku.com/changelog-items/2446) Since then every deployment to Heroku of our existing django 4.0 application fails during the release phase, the build…
Simon
  • 413
  • 3
  • 6
28
votes
8 answers

Heroku code=H10 desc="App crashed" - Can't figure out why it's crashing

I've been searching around on this one for a while and can't find anything that seems to be applicable in my situation. I've been staring at these logs and I can't see what the problem is. This has happened during deployments before, but always…
mgreich
  • 381
  • 1
  • 3
  • 3
24
votes
5 answers

Can't connect to heroku postgresql database from local node app with sequelize

I'm trying to connect to a Heroku postgresql database from a local nodejs app with Sequelize. I followed this two guides an everything is working perfectly fine on the heroky server side, but my node app won't connect to heroku when I run it locally…
clemlatz
  • 7,543
  • 4
  • 37
  • 51
23
votes
4 answers

OperationalError: cursor "_django_curs_" does not exist

We have an online store web-app which is powered by django, postgresql and heroku. For a specific campaign (you can think a campaign like a product to purchase), we have sold 10k+ copies successfully. Yet some of our users are encountered this…
dhargan
  • 408
  • 1
  • 3
  • 16
20
votes
7 answers

How to use php artisan migrate command of Laravel4 in Heroku?

I am suing Heroku dev plan for creating database using PostgreSQL. Database is created in Heroku. After running heroku pg:info command $ heroku pg:info === HEROKU_POSTGRESQL_XXX_URL Plan: Hobby-dev Status: available Connections: 1 PG…
niran
  • 1,920
  • 8
  • 34
  • 60
20
votes
4 answers

How much disk space do heroku plans have?

I creating an app that works like an DMS(Document Management System) so my client will be uploading PDF's, XLS's and DOC's.
Marco
  • 315
  • 1
  • 3
  • 13
1
2 3
…
70 71