Performing physical backup and restore for the EDB Postgres service
Upgrade to IBM Software Hub Version 5.1 before IBM Cloud Pak for Data Version 4.8 reaches end of support. For more information, see Upgrading from IBM Cloud Pak for Data Version 4.8 to IBM Software Hub Version 5.1.
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.