On 06/06/2016 05:32 PM, Patrick B wrote:
> My set up:
>
>
> Master --> slave01 (streaming replication) --> slave02 (streaming
> replication)
> Master --> slave03 (wal_files 4 days old, not streaming replication)
>
> The wal_files are stored into each server.
> But when the slave03 was down, the wal_files weren't being copied into
> it. We took too long to discover that, and now we lost some wal_files..
> they've been recycled...
>
> So my question is:
>
> Can I just do a RE-SYNC from slave01 to slave03 of the data folder?
Are you archiving the WAL files on slave01?
Otherwise I would expect they would have been recycled there also.
> Or do I have to sync all the database again?
I tend to believe so.
Have you taken a look at?:
https://www.postgresql.org/docs/9.2/static/app-pgbasebackup.html
Pay extra attention to the section:
-X method
--xlog-method=method
>
> I'm asking because the DB is 2.2TB, don't wanna do one step and discover
> later that did not work and have to do all over again
>
> Cheers
> Patrick
--
Adrian Klaver
adrian.klaver@aklaver.com