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.