PostgreSQL Backup and Restore with pg_dump and pg_restore
A working backup is the difference between a bad afternoon and a bad week. PostgreSQL provides pg_dump and pg_restore for logical backups. These client utilities work with local or remote databases and produce portable archives that you can load into a compatible PostgreSQL server. This guide explains how to use pg_dump for single databases, pg_dumpall…









