Re: Help setting up warm standby replication

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Help setting up warm standby replication
Дата
Msg-id 23483.1176588558@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Help setting up warm standby replication  (Nico Sabbi <nsabbi@officinedigitali.it>)
Ответы Re: Help setting up warm standby replication
Список pgsql-general
Nico Sabbi <nsabbi@officinedigitali.it> writes:
> To begin with I followed the example of the docs: in the recovery.conf
> file of the
> slave instance I  set

> restore_command = 'cp -av /var/lib/pgsql/data/pg_xlog/%f  %p'

Hm, it looks like you are trying to copy xlog segments straight from the
pg_xlog directory of the master?  That's not going to work, because the
master will rename/overwrite those files as soon as it thinks it's done
with them.  You need to have an archive_command on the master that is
really truly copying the data to somewhere else, and then the
restore_command should copy from the somewhere else.

            regards, tom lane

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

Предыдущее
От: "Anton Melser"
Дата:
Сообщение: Re: postgresql 8.1.4 to 8.2.3
Следующее
От: Tom Lane
Дата:
Сообщение: Re: error creating/setting sequence, pg_dump / pg_restore 8.1.5