Re: Integrating Replication into Core - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Integrating Replication into Core
Date
Msg-id 20061122184835.GI6804@alvh.no-ip.org
Whole thread Raw
In response to Integrating Replication into Core  (Markus Schiltknecht <markus@bluegap.ch>)
Responses Re: Integrating Replication into Core  (Markus Schiltknecht <markus@bluegap.ch>)
Re: Integrating Replication into Core  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Markus Schiltknecht wrote:

> >However, there may not be nifty syntax changes nor GUCs in core to
> >support a specific implementation of a replicator.
> 
> I'd love to get into that one. Some of the people who have attended my 
> talk at the summit might know that I've introduced the following syntax 
> to Postgres-R:
> 
> ALTER DATABASE testdb START REPLICATION IN GROUP testgroup USING egcs;
> 
> And I'm using the system catalogs to store replication settings. What's 
> so wrong with that?

I don't know if there's anything wrong, but in Mammoth Replicator, the
syntax to enable replication of a single table is 

ALTER TABLE foo ENABLE REPLICATION 

and we store the replication settings in system catalogs as well.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: FKs + partial indexes?
Next
From: Markus Schiltknecht
Date:
Subject: Re: Integrating Replication into Core