Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help

Поиск
Список
Период
Сортировка
От Bert
Тема Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
Дата
Msg-id CAFCtE1=UdQjXGXqwTOwt5AZbxXjEC55gHw_Uq0nnHzk0Tqcs4A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список pgsql-admin
Дерево обсуждения
Hello Yuval,

I would suggest to buy a third server if you want to do synchronous replication.

However, if your network is broken, I would first fix the network. :)

cheers,
Bert


On Thu, Apr 18, 2013 at 6:13 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
On Apr 18, 2013, at 9:40 AM, Sofer, Yuval wrote:

> Is there any parameter that I can use, to enable recovering from hanging on until someone of us re-establish connection to secondary DB?
> Maybe some configuration parameter that sets the time interval for being stuck because of unavailable secondary Postgres?

No, that's what synchronous means. What you're describing is asynchronous, and it seems like you should consider using asynchronous replication.

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice






--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



--
Bert Desmet
0477/305361

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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
Следующее
От: chanh.tran@free.fr
Дата:
Сообщение: Pb migrating database from Postgres 8.1 to 8.4