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 successf...

I'm trying to connect a Heroku Postgres database to Google Looker Studio (former Data Studio). I found an old stack overflow question that suggests I need to use SSL and for that I need to enable c...

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...

I am trying to run my first migration which creates a single table in a Heroku postgres database. When I try to run knex migrate:latest --env development I receive the error Error: Unable to ...

As the title states, I am using Prisma 2 in a Next JS app. I have a very simple schema: model User { id Int @id @default(autoincrement()) firstName String middleName String? firstLastname Stri...

I want to push my local postgresql database to heroku, using heroku pg:push command. The command looks like this: heroku pg:push mylocaldb DATABASE --app sushi according to the heroku document: htt...

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:4...

I am having some difficulties with restoring the schema of a table. I dumped my Heroku Postgres db and I used pg_restore to restore one table from it into my local db (it has more than 20 tables). ...

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 o...

Due to this change by heroku, I am not able to restore my Heroku Postgres backup. Following errors are thrown while restoring: pg_restore: error: could not execute query: ERROR: extension "pg_...

I am connecting my parse-server application to a PostgreSQL database hosted on the Heroku-PostgreSQL service. My database is with a schema called gc which is different to the default public schema...

Im using heroku and postgres. Local is working fine but whenever the user (any user) performs an INSERT on stage it crashes. This is the message i get: PG:InsufficientPrivilege: ERROR: permission ...

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 a...

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 i...

I am following this set of instructions provided by Heroku to export a copy of my local postgis database and restore it to my Heroku postgres instance. I further followed this set of instruct...

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-de...

I'm trying to deploy my Rails app to Heroku and when I add the pg gem to my gemfile and run bundle install I get an error: An error occurred while installing pg (1.1.3), and Bundler cannot continu...

There are a number of Heroku CLI Postgres commands that all return the same error. For example: $ heroku pg:bloat psql: FATAL: no pg_hba.conf entry for host "...", user "...", database "...", SSL ...

Now that I've deployed my webapp to Heroku, how would I be able to browse the database as it's altered over time?

I'm trying to troubleshoot the pg_restore command on my system. I've installed Postgresapp, and I've included its binaries on my PATH. Commands such as psql and pg_dump appear to work fine, and run...

We're on Heroku and trying to understand if it's time to upgrade our Postgres database or not. I have two questions: Is there any tools you know of that track heroku postgres logs to track their ...

I am trying to use Heroku review apps for testing and demonstrating my site to my colleagues. The site has a large database that will not function with Heroku's free hobby-dev databases. I am tryi...

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 h...

I am developing a simple PHP application running on Heroku. I have created a CSV file and am using it as a simple database. Now I want to create a database on Heroku, so I added a Postgres instan...

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 co...