Postgres Pro
Downloads
Home   >   mailing lists

Re: PITR Setup Using Hot StandBy - Mailing list pgsql-admin

From Dave Johansen
Subject Re: PITR Setup Using Hot StandBy
Date
Msg-id CAAcYxUdhENM5Add1hYu0kv4DFC4ru=KS1Qs8FjgSS0c-kf0hTQ@mail.gmail.com
Whole thread Raw
In response to PITR Setup Using Hot StandBy  ("Vicky Soni - Quipment India" <vicky.soni@quipment.nl>)
Responses Re: PITR Setup Using Hot StandBy
List pgsql-admin
Tree view
On Tue, May 24, 2016 at 6:05 AM, Vicky Soni - Quipment India <vicky.soni@quipment.nl> wrote:

Quipment Logo

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).
Attachment

pgsql-admin by date:

Previous
From: "Campbell, Lance"
Date:
Subject: question marks in logs
Next
From: Scott Whitney
Date:
Subject: Re: PITR Setup Using Hot StandBy