From: | Ankur Kaushik <ankurkaushik(at)gmail(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | PITR using pg_basebackup ERROR |
Date: | 2015-10-29 11:24:54 |
Message-ID: | CALXoLqxFPmKEPv1V+BaiQbkdPuXqX_sKxLTSDnzXU1Dbb3WCrQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Vladimir Borodin | 2015-10-29 11:35:27 | Re: [ADMIN] Replication slots and isolation levels |
Previous Message | Michael Paquier | 2015-10-29 11:03:41 | Re: [ADMIN] Replication slots and isolation levels |