Re: Configuring synchronous replication - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Configuring synchronous replication
Date
Msg-id 4C96FF63.8050808@enterprisedb.com
Whole thread Raw
In response to Re: Configuring synchronous replication  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 19/09/10 01:20, Robert Haas wrote:
> On Sat, Sep 18, 2010 at 5:42 PM, Josh Berkus<josh@agliodbs.com>  wrote:
>> There are considerable benefits to having a standby registry with a
>> table-like interface.  Particularly, one where we could change
>> replication via UPDATE (or ALTER STANDBY) statements.
>
> I think that using a system catalog for this is going to be a
> non-starter, but we could use a flat file that is designed to be
> machine-editable (and thus avoid repeating the mistake we've made with
> postgresql.conf).

Yeah, that needs some careful design. We also need to record transient 
information about each slave, like how far it has received WAL already. 
Ideally that information would survive database restart too, but maybe 
we can live without that.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Configuring synchronous replication
Next
From: Vaibhav Kaushal
Date:
Subject: Postgres Licensing