Re: PITR Setup Using Hot StandBy - Mailing list pgsql-admin
Hi, Dave.
It depends on what you're trying to do.
If you want a slave up in real-time replication mode, that's by far the simplest setup.
The concept is:
1) start a backup
select pg_start_backup("myslave"),true);
2) Rsync (or tar) your pg data directory over to your slave.
3) select pg_stop_backup();
4) Tell your slave how to connect to the master
Start your slave.
This is a pretty straight-forward link for this:
https://opensourcedbms.com/dbms/how-to-do-point-in-time-recovery-with-postgresql-9-2-pitr-3/
 | opensourcedbms.com This post describes how to do point in time recovery with PostgreSQL 9.2 : PITR. Point in time recovery (PITR) simply means restoring data upto certain point in time. | |
If you want to do something "clever," like offset how far behind the slave is, that's more complex.
Sent: Tuesday, May 24, 2016 10:31 AM
To: Vicky Soni - Quipment India
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] PITR Setup Using Hot StandBy
Hello Friends,
I need to setup PITR. Using master, I am able to do wal archiving.
But using slave I am not able to archive WAL files.
Can anyone please guide me, how to setup PITR using Hot StandBy?
I have setup LogShpping + Streaming Replication in my dev environment, now using this slave I want to setup PITR.
I have already setup following parameters:
wal_level = hot_standby
archive_mode = on
archive_command = 'copy "c:\\Program Files\\PostgreSQL\\9.4\\data\\%p" "\\\\192.168.170.221\\Primary_WAL_Archive\\%f"'
max_wal_senders = 3
wal_keep_segments = 8
hot_standby = on
Any help is appreciated.
http://www.postgresql.org/docs/9.2/static/continuous-archiving.html
Austin, TX 78757
www.journyx.com
Attachment
pgsql-admin by date: