Horton

Re: Configuring synchronous replication

Joshua D. Drake <jd@commandprompt.com>

View thread
From: "Joshua D. Drake" <jd@commandprompt.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, Thom Brown <thom@linux.com>, Dave Page <dpage@pgadmin.org>, Fujii Masao <masao.fujii@gmail.com>, Josh Berkus <josh@agliodbs.com>, <pgsql-hackers@postgresql.org>
Date: 2010-09-22T00:25:47Z
Lists: 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@momjian.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