Re: Re-sync slave server

On 06/06/2016 05:11 PM, Patrick B wrote:
> Hi guys,
>
> I'm using PostgreSQL 9.2
>
> There is a backup server that is 4 days old replication by wal_files
> (not streaming)
>
> However, the server went down and I lost some wal_files.. and now the
> replication is not working...

What is your set up?:

        standby server
master --> | WAL archive --> standby_cluster


OR

              wal storage   standby server
master --> | WAL archive | --> standby

In other words where did you lose the WAL files?

More to the point are they still on the master or have they already been
recycled?

>
> Question:
>
> Do I need to sync all the data folder from my master....
>
> Or just doing an incremental rsync would work?
>
> Thanks
> Patrick


--
Adrian Klaver
adrian.klaver@aklaver.com