PostgreSQL 16 : Backup and Restore2024/02/09 |
For Backup and Restore PostgreSQL Data, it's possible to run with [pg_dump] and [pg_restore].
|
|
[1] | Backup Databases. |
# available types for [--format=*]
# p = plain (SQL)
# c = custom (compression)
# t = tar
# d = directory
# [freebsd] user takes backup of [testdb]
freebsd@www:~ $ pg_dump -U freebsd --format=t -d testdb > pg_testdb.tar freebsd@www:~ $ ls -l total 1 -rw-r--r-- 1 freebsd freebsd 6656 Feb 9 13:33 pg_testdb.tar # admin user [postgres] takes backup of all databases postgres@www:~ $ mkdir ~/backups postgres@www:~ $ pg_dumpall -f ~/backups/pg_DB_all.sql postgres@www:~ $ ls -l ~/backups total 5 -rw-r--r-- 1 postgres postgres 3271 Feb 9 13:34 pg_DB_all.sql |
[2] | Restore Databases. |
# [freebsd] user restores [testdb] database from backup file freebsd@www:~ $ pg_restore -U freebsd -d testdb pg_testdb.tar
# admin user [postgres] restores all database from backup file # if the type of backup file is SQL text, use [psql] command for restoring postgres@www:~ $ psql -f ~/backups/pg_DB_all.sql |
Sponsored Link |
|