Re: Re-sync slave server - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Re-sync slave server
Date
Msg-id 7d66ef4f-f03a-60f3-e928-f895e868c7ab@aklaver.com
Whole thread Raw
In response to Re-sync slave server  (Patrick B <patrickbakerbr@gmail.com>)
Responses Re: Re-sync slave server  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: Re-sync slave server
Next
From: Patrick B
Date:
Subject: Re: Re-sync slave server