Re: Re-sync slave server

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(dot)klaver(at)aklaver(dot)com