The pg_dump and pg_restore commands provide excellent flexibility in storing a compressed dump file, and selectively restoring any part of it. I’ve found that dropping and re-creating the target database is the cleanest way to restore a dumpfile — no stray relations left to cause trouble. Unless you own all of the objects being restored, [...]
Posts Tagged ‘database backup’
PostgreSQL Dump and Restore Notes
Posted in Open Source, Software, System Administration, Technique, tagged PostgreSQL, pg_dump, pg_restore, database backup on May 16, 2010 | Leave a Comment »
