Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue
Дата
Msg-id CA+h6AhgKZT_EUOG9ALXW3gowTUNg5jKOvb66ZRgxrt2WdOT=QQ@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERA]: Postgresql-9.1.1 synchronous replication issue  (Venkat Balaji <venkat.balaji@verse.in>)
Ответы Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue
Список pgsql-general
Дерево обсуждения
What is the value of synchronous_commit ?

---
Regards,
Raghavendra
EnterpriseDB Corporation



On Thu, Feb 2, 2012 at 12:21 PM, Venkat Balaji <venkat.balaji@verse.in> wrote:
Hello,

I was testing the Postgres-9.1.1 synchronous streaming replication on our UAT system.

Without synchronous replication, everything was working fine.

But, when i enabled synchronous_replication_names='*', the "create table" started hanging for long time.

When i pressed "Ctrl+C" i got the following message -

Cancel request sent
WARNING:  canceling wait for synchronous replication due to user request
DETAIL:  The transaction has already committed locally, but might not have been replicated to the standby.
CREATE TABLE

Can someone please help us ?

Thanks
VB

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