Top "Heroku-postgres" questions

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

Push database to heroku: how to use heroku pg:push

I want to push my local postgresql database to heroku, using heroku pg:push command. The command looks like this: …

heroku database-migration heroku-postgres
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 …

node.js postgresql heroku sequelize.js heroku-postgres
Cant pg_restore on Heroku: "could not read from input file: end of file"

I am trying to copy my local PostgreSQL DB to Heroku app with pg_dump / pg_restore utils. Doing according …

postgresql heroku heroku-postgres
Postgres.app: pg_restore hangs

I'm trying to troubleshoot the pg_restore command on my system. I've installed Postgresapp, and I've included its binaries on …

macos postgresql osx-mountain-lion heroku-postgres
Low Postgres Cache Hit Ratio - data size or something else?

I've just upgraded my Heroku postgres database from the Kappa plan (800MB RAM, postgres 9.1) to the Ronin plan (1.7GB RAM, …

postgresql heroku postgresql-9.1 postgresql-9.2 heroku-postgres
Knex migration in postgres Heroku - Error: Unable to acquire connection

I am trying to run my first migration which creates a single table in a Heroku postgres database. When I …

node.js heroku database-migration knex.js heroku-postgres
PG::ConnectionBad: could not connect to server: Connection refused

I have the following error when I try to run git heroku push master I don't how solve the problem. …

ruby-on-rails ruby-on-rails-3 heroku ruby-on-rails-3.2 heroku-postgres
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 …

postgresql heroku heroku-toolbelt heroku-postgres
Heroku Postgres: "psql: FATAL: no pg_hba.conf entry for host"

There are a number of Heroku CLI Postgres commands that all return the same error. For example: $ heroku pg:bloat …

postgresql heroku heroku-postgres heroku-cli postgres-10