The heroku tag has no wiki summary.
1
vote
0answers
35 views
Write performance of Postgresql 9.1 with read-only slave
I have a Postgresql 9.1 database that is being hosted by Heroku. It currently has a read-only "follower". I need to truncate several large tables (over 100GB) of data and reloads them. Is the ...
2
votes
0answers
38 views
What is the equivalent of a “Certificate of Destruction” when using a cloud-hosted database?
We have a Rails application hosted by Heroku and using an Heroku Postgres database. Some of the information we store is considered to be sensitive by our users, and we've been asked if we can provide ...
2
votes
0answers
178 views
“custom archiver out of memory” error when restoring large DB using pg_restore
I'm trying to a restore a local copy of a 30GB DB (with only one table) dumped using the Heroku wrappers (described here) using pg_restore. The Heroku DB is using 9.1.7 and I have had the same result ...
5
votes
2answers
136 views
How can I export a subset of tabledata from a prodution database into my local testing database?
We have a relatively big production postgres based db: ~20GB.
The PostgreSQL database is hosted on heroku.
I would like to copy a small subset of the table data to my local database so I can run ...
0
votes
1answer
151 views
Heroku PostgresApp - Fails to start with edited postgresql.conf
I am trying to tune my local pg running from the Heroku Postgress App.
I am seeing strange errors in the OSX console whenever I change some of the internal settings:
PM Postgres[78709]: Could not ...
0
votes
0answers
108 views
heroku pg:info shows 0 tables
My heroku app has dev plan.
The app is useable and works and if I use pg:backups to download a backup and view it locally I can see that it has data.
However, when I do heroku pg:info, it gives me 0 ...
2
votes
1answer
302 views
Ensure correct username when using pg_restore
I have just installed postgres 9.1.6 on a local Ubuntu server. Now I'm trying to restore a database dump from a database on Heroku. The local database is setup like this:
sudo -u postgres psql -c ...
