Re: Re-sync slave server

Поиск
Список
Период
Сортировка
От Patrick B
Тема Re: Re-sync slave server
Дата
Msg-id CAJNY3itvKjEUD2iPLMb1g5nrNp2cUYPy95f+ORQUZ5RPfx-SSw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re-sync slave server  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Re-sync slave server  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Re-sync slave server  (bricklen <bricklen@gmail.com>)
Список pgsql-general
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?

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

В списке pgsql-general по дате отправления:

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