Re: PITR Setup Using Hot StandBy

On Tue, May 24, 2016 at 6:05 AM, Vicky Soni - Quipment India <
vicky(dot)soni(at)quipment(dot)nl> wrote:

> [image: 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).