Re: (13.1) pg_basebackups ./. pg_verifybackup

postgres@db:~/playground/demo$ initdb -D db 2>/dev/null 1>&2

postgres@db:~/playground/demo$ pg_ctl -D db -l logfile start 2>/dev/null 1>&2

postgres@db:~/playground/demo$ psql -c 'create table t(id int primary key); insert into t select x from generate_series(1, 10000) x;'

INSERT 0 10000

postgres@db:~/playground/demo$ pg_basebackup -U postgres -Ft -z -D basebackup

postgres@db:~/playground/demo$ echo $?

0

postgres@db:~/playground/demo$ cd basebackup

postgres@db:~/playground/demo/basebackup$ ls

backup_manifest  base.tar.gz  pg_wal.tar.gz

postgres@db:~/playground/demo/basebackup$ tar xzf base.tar.gz

postgres@db:~/playground/demo/basebackup$ cd pg_wal/

postgres@db:~/playground/demo/basebackup/pg_wal$ mv ../pg_wal.tar.gz . # pg_wal.tar.gz file has to uncompressed in pg_wal dir

postgres@db:~/playground/demo/basebackup/pg_wal$ tar xzf pg_wal.tar.gz

postgres@db:~/playground/demo/basebackup/pg_wal$ cd ../..

postgres@db:~/playground/demo$ find basebackup -name '*tar.gz'

basebackup/base.tar.gz

basebackup/pg_wal/pg_wal.tar.gz

postgres@db:~/playground/demo$ find basebackup -name '*tar.gz' -delete

postgres@db:~/playground/demo$ find basebackup -name '*tar.gz'

postgres@db:~/playground/demo$ pg_verifybackup basebackup

backup successfully verified

Backup and Restore a PostgreSQL Cluster With Multiple Tablespaces Using pg_basebackup - Percona Database Performance Blog