Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?

Поиск
Список
Период
Сортировка
От Douglas J Hunley
Тема Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?
Дата
Msg-id CALxYTP6ZCEh4_oWuAcuXZFpGks9ONd3qd0YT7GTgk104ohomFg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?  (David Guyot <david.guyot@europecamions-interactive.com>)
Список pgsql-admin
Дерево обсуждения

On Tue, Apr 2, 2013 at 10:53 AM, David Guyot <david.guyot@europecamions-interactive.com> wrote:
Thank you for your answer. I had in mind that this line was for the initial start of the standby; should I just comment it before promoting the standby, or is this line useless for the day-to-day standby service?

If you're going to do WAL shipping, your 'archive_command' on the master needs to be copying over to the standby (rsync or whatever). Then the standby's recovery.conf would be a simple 'cp /path/to/wal-archive' type of command. 


--
Douglas J Hunley (doug.hunley@gmail.com)
Twitter: @hunleyd                                               Web: douglasjhunley.com
G+: http://goo.gl/sajR3

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

Предыдущее
От: David Guyot
Дата:
Сообщение: Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?
Следующее
От: Douglas J Hunley
Дата:
Сообщение: Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?