#Introduction
In this tutorial, How to backup and restore a Postgres database. You have installed the PostgreSQL database system.
Backup and restore a Postgres database
Backup a PostgreSQL Database
PostgreSQL provides the pg_dump utility to help you back up databases.
Example: import and export my-db database as below
The output format is a plain-text SQL script file ( The default)
root@5cc6d8f56baf:/# pg_dump -h localhost -U devopsroles my-db > my-db.sqlYou can compress this data by using the “custom” dump format:
# format tar
root@5cc6d8f56baf:/# pg_dump -h localhost -U devopsroles -F t my-db > my-db.tarBackup use pg_dump via a compression tool such as gzip
root@5cc6d8f56baf:/# pg_dump -h localhost -U devopsroles my-db | gzip > my-db.gzBackup Remote PostgreSQL Databases
pg_dump -U devopsroles -h 192.168.1.122 -p 5432 my-db > my-db.sqlExplain:
- -U: to specify the database role name
- -h: remote host
- -p: port a PostgreSQL database
To back up all PostgreSQL databases
root@5cc6d8f56baf:/# pg_dumpall -h localhost -U devopsroles > all_pg_dbs.sqlRestore the dump using the psql command
pgsql -f all_pg_dbs.sql postgresRestoring a PostgreSQL Database
You can use psql or pg_restore utilities
Example:
root@5cc6d8f56baf:/# psql -h localhost -U devopsroles my-db < my-db.sqlroot@5cc6d8f56baf:/# pg_restore -h localhost -U devopsroles -d my-db my-db.tarConclusion
You have Backup and restore a Postgres database. I hope will this your helpful. Thank you for reading the DevopsRoles page!
