Performing physical backup and restore for the EDB Postgres service

EDB Postgres uses dedicated backup and restore utilities.

Backup a database

To backup a database, use the pg_dump utility. This will extract a PostgreSQL database into a script file. Backups can be made consistently, regardless of whether the database is being used concurrently.

pg_dump [connection-option...] [option...] [dbname]

For more information on pg_dump, see https://www.postgresql.org/docs/current/app-pgdump.html.

Restore a database

To restore a database, use the pg_restore utility. This will restore a PostgreSQL database from an archive file created by pg_dump. The database will be reconstructed to the state it was in at the time it was saved.

pg_restore [connection-option...] [option...] [filename]

For more information on pg_restore, see https://www.postgresql.org/docs/current/app-pgrestore.html.