How to backup/restore standalone heroku postgres database?
Is there a Heroku way to backup / restore a standalone postgres database
at https://postgres.heroku.com/ apart from using pg_dump / pg_restore ?
I can create a dump using
pg_dump --verbose -F c -b -h hostname -p port -U username -f "backup.dump"
-d database_name
and restore it using
pg_restore --verbose --clean --no-acl --no-owner -h hostname -p port -U
username -d database_name "backup.dump"
No comments:
Post a Comment