Postgres Pro
Downloads
Home   >   mailing lists

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

From bricklen
Subject Re: Re-sync slave server
Date
Msg-id CAGrpgQ8ag62=1TMEDBTe5SoNjU8xid3OOzDq=A1LRfc5JoQLGw@mail.gmail.com
Whole thread Raw
In response to Re: Re-sync slave server  (Patrick B <patrickbakerbr@gmail.com>)
Responses Re: Re-sync slave server  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
Tree view

On Mon, Jun 6, 2016 at 5:32 PM, Patrick B <patrickbakerbr@gmail.com> 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?
Or do I have to sync all the database again?


If the master is successfully shipping WALs to slave03 now, re-syncing that replica from slave01 (or slave02) should work fine. By "re-sync" I assume you mean a full filesystem copy using pg_basebackup etc.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Re-sync slave server
Next
From: Alvaro Herrera
Date:
Subject: Re: Postgres Dropped DB have recovered files how to restore