Category "heroku-postgres"

Using heroku pg:backups:restore to Import to Heroku Postgres

I am trying to copy a local PostgreSQL database to Heroku per this article. Here is what I have done: 1. Make a dump file pg_dump -Fc --no-acl --no-owner -h loc

Using heroku pg:backups:restore to Import to Heroku Postgres

I am trying to copy a local PostgreSQL database to Heroku per this article. Here is what I have done: 1. Make a dump file pg_dump -Fc --no-acl --no-owner -h loc

How I can access postgres log_connections logs

I see that log_connections enabled by default on Heroku PostgreSQL instance, but how I can get this log?

Accessing heroku private space database over AWS VPC peering connection

I've successfully setup VPC peering from my AWS VPC to my heroku private space, and configured the routing from the VPC for the heroku private space CIDR. Howev