On Tue, May 24, 2016 at 6:05 AM, Vicky Soni - Quipment India <vicky.soni@xxxxxxxxxxx> wrote:
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
The standby/slave is read only and does not generate WAL files (it only consumes them to stay in sync with the master).
