Re: (13.1) pg_basebackups ./. pg_verifybackup

Поиск
Список
Период
Сортировка
От Vijaykumar Jain
Тема Re: (13.1) pg_basebackups ./. pg_verifybackup
Дата
Msg-id CAM+6J96QjiaBDKOemvqCddmrJn3PYpE_m91iyheyfE6TQUCPXA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: (13.1) pg_basebackups ./. pg_verifybackup  (Matthias Apitz <guru@unixarea.de>)
Ответы Re: (13.1) pg_basebackups ./. pg_verifybackup  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Re: (13.1) pg_basebackups ./. pg_verifybackup  (Matthias Apitz <guru@unixarea.de>)
Список pgsql-general

Could some kind sol acknowledge me that this is the correct procedure to
use pg_verifybackup? Thanks in advance


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



--
Thanks,
Vijay
Mumbai, India

В списке pgsql-general по дате отправления:

Предыдущее
От: Matthias Apitz
Дата:
Сообщение: Re: (13.1) pg_basebackups ./. pg_verifybackup
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: Re: (13.1) pg_basebackups ./. pg_verifybackup