Re: Demoting master to slave without an rsync...is it safe?

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Demoting master to slave without an rsync...is it safe?
Дата
Msg-id 4E67E8F6.9040101@hogranch.com
обсуждение исходный текст
Ответ на Re: Demoting master to slave without an rsync...is it safe?  (Chris Redekop <chris@replicon.com>)
Список pgsql-general
On 09/07/11 2:43 PM, Chris Redekop wrote:
> my original question was: is it safe to bring a former master back up
> as a slave without doing a base-backup first? (using
> recovery_target_timeline='latest')
>

no.  you must first sync the new slave's files from the current master.
if you can do this with rsync odds are most of the old files on the
master won't need copying.   of course, this sync must be bracketed with
the same pg_start_backup() and pg_end_backup() as when the original
slave was created.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


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

Предыдущее
От: Chris Redekop
Дата:
Сообщение: Re: Demoting master to slave without an rsync...is it safe?
Следующее
От: "David Johnston"
Дата:
Сообщение: Re: Problem using PostgreSQL 9.0.4 with Java