PITR using pg_basebackup ERROR - Mailing list pgsql-admin
| From | Ankur Kaushik |
|---|---|
| Subject | PITR using pg_basebackup ERROR |
| Date | |
| Msg-id | CALXoLqxFPmKEPv1V+BaiQbkdPuXqX_sKxLTSDnzXU1Dbb3WCrQ@mail.gmail.com Whole thread Raw |
| Responses |
Re: PITR using pg_basebackup ERROR
(Kevin Grittner <kgrittn@ymail.com>)
Re: PITR using pg_basebackup ERROR (Jerry Sievers <gsievers19@comcast.net>) |
| List | pgsql-admin |
I Have to Take the backup from on server and to restore to other server using PITR
I did below steps for PITR
On Master Server :
wal_level = hot_standby
archive_mode = on
archive_command = 'test ! -f /var/lib/pgsql/pg_log_archive/%f && cp %p /var/lib/pgsql/pg_log_archive/%f'
max_wal_senders = 2
mkdir /var/lib/pgsql/pg_log_archive/
chown postgres.postgres /var/lib/pgsql/pg_log_archive/
chmod 700 /var/lib/pgsql/pg_log_archive/
su - postgres
psql -c "CREATE ROLE base_backup_user REPLICATION LOGIN PASSWORD 'backupuser';"
/etc/init.d/postgresql-9.4 restart
pg_basebackup -h127.0.0.1 -U base_backup_user -D /var/lib/pgsql/backup -Ft -z -P
Now I transfer /var/lib/pgsql/backup/base.tar.gz to other server location /var/lib/pgsql/9.4/data
also transfer /var/lib/pgsql/pg_log_archive/ to other server with same location ,
On target server
in recovery.conf
restore_command = 'cp /var/lib/pgsql/pg_log_archive/%f %p'
ERROR IN ERROR LOG
======================
< 2015-10-29 14:21:13.189 MSK >LOG: database system was interrupted; last known up at 2015-10-29 12:41:45 MSK
< 2015-10-29 14:21:13.230 MSK >LOG: starting archive recovery
< 2015-10-29 14:21:13.247 MSK >LOG: restored log file "000000010000000000000029" from archive
< 2015-10-29 14:21:13.434 MSK >LOG: redo starts at 0/29000024
< 2015-10-29 14:21:13.434 MSK >LOG: consistent recovery state reached at 0/29000110
cp: cannot stat `/var/lib/pgsql/pg_log_archive/00000001000000000000002A': No such file or directory
< 2015-10-29 14:21:13.436 MSK >LOG: redo done at 0/29000110
< 2015-10-29 14:21:13.459 MSK >LOG: restored log file "000000010000000000000029" from archive
cp: cannot stat `/var/lib/pgsql/pg_log_archive/00000002.history': No such file or directory
< 2015-10-29 14:21:13.463 MSK >LOG: selected new timeline ID: 2
cp: cannot stat `/var/lib/pgsql/pg_log_archive/00000001.history': No such file or directory
< 2015-10-29 14:21:13.800 MSK >LOG: archive recovery complete
< 2015-10-29 14:21:14.001 MSK >LOG: MultiXact member wraparound protections are now enabled
< 2015-10-29 14:21:14.002 MSK >LOG: database system is ready to accept connections
< 2015-10-29 14:21:14.003 MSK >LOG: autovacuum launcher started
=========================
In Location of second server /var/lib/pgsql/pg_log_archive
-rw------- 1 postgres postgres 16M Oct 29 13:54 000000010000000000000023
-rw------- 1 postgres postgres 305 Oct 29 13:54 000000010000000000000024.00000024.backup
-rw------- 1 postgres postgres 16M Oct 29 13:54 000000010000000000000024
-rw------- 1 postgres postgres 16M Oct 29 14:05 000000010000000000000025
-rw------- 1 postgres postgres 16M Oct 29 14:09 000000010000000000000026
-rw------- 1 postgres postgres 16M Oct 29 14:25 000000010000000000000027
-rw------- 1 postgres postgres 16M Oct 29 15:11 000000010000000000000028
-rw------- 1 postgres postgres 305 Oct 29 15:11 000000010000000000000029.00000024.backup
-rw------- 1 postgres postgres 16M Oct 29 15:11 000000010000000000000029
-rw------- 1 postgres postgres 42 Oct 29 16:51 00000002.history
pgsql-admin by date: