Re: Configuring synchronous replication

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Thom Brown <thom(at)linux(dot)com>, Dave Page <dpage(at)pgadmin(dot)org>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Configuring synchronous replication
Date: 2010-09-22 00:25:47
Message-ID: 3b3c1edef4f99665bac9be63f7176167@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers


> Crazy idea, but could we use format like postgresql.conf by extending
> postgresql.conf syntax, e.g.:
>
> server1.failover = false
> server1.keep_connect = true
>

Why is this in the config file at all. It should be:

synchronous_replication = TRUE/FALSE

then

ALTER CLUSTER ENABLE REPLICATION FOR FOO;
ALTER CLUSTER SET keep_connect ON FOO TO TRUE;

Or some such thing.

Sincerely,

Joshua D. Drake

> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + It's impossible for everything to be true. +

--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2010-09-22 08:10:54 Re: Configuring synchronous replication
Previous Message Josh Berkus 2010-09-22 00:04:55 Re: Configuring synchronous replication

Browse pgsql-hackers by date

  From Date Subject
Next Message Pei He 2010-09-22 00:37:42 Re: Get the offset of a tuple inside a table
Previous Message Elvis Pranskevichus 2010-09-22 00:06:24 Re: moving development branch activity to new git repo