Re: Re-sync slave server

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: Re-sync slave server
Дата
Msg-id CAGrpgQ8ag62=1TMEDBTe5SoNjU8xid3OOzDq=A1LRfc5JoQLGw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re-sync slave server  (Patrick B <patrickbakerbr@gmail.com>)
Ответы Re: Re-sync slave server  (Patrick B <patrickbakerbr@gmail.com>)
Список pgsql-general

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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Re-sync slave server
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Postgres Dropped DB have recovered files how to restore