PostgreSQL Backup/Restore
- by Ian
What's the best way to backup a postgresql database?
I've tried using the documentation at www.postgresql.org, but I always get integrity errors when restoring.
Right now I'm using this for backup:
pg_dump -U myuser -d mydatabase db.pg.dump
for restore:
pg_restore -c -r -U myuser -d mydatabase db.pg.dump
But I'm not getting the desired results..