Re: Postgres-R

Hi,

leiyonghua wrote:
> ./configure --enable-replication
> make & make install

You certainly also want --enable-debug and --enable-cassert, maybe also 
additional flags for the C compiler, like -DRMGR_DEBUG, please check the 
source code for these.

> 4. install the GCS ensemble, according the document : 
> http://www.cs.technion.ac.il/dsl/projects/Ensemble/doc.html
> 
> 5. start ensemble daemon and gossip if neccessary ( yes, make sure the 
> two nodes can 'GCS' each other)

Yeah, either use the gossip process, or make sure IP multicast works for 
your network configuration. I admit that ensemble is quite a beast WRT 
compilation and configuration.

> 3. Assume that you have two nodes, start up postgresql and create a 
> database 'db', and create a table 'tb' for testing which should be have 
> a primary key for all nodes.
> 
> 4. At the origin node, execute the command at psql console:
> alter database db start replication in group gcs;
> (which means the database 'db' is the origin and the group 'gcs' is the 
> GCS group name)
> 
> 5. At the subscriber node, execute the command:
> alter database db accept replication from group gcs;

As recovery doesn't work automatically, you still need to sync the 
complete database from the node which initiated the replication group. 
Then accept replication.

I'm working on automatic recovery.

Regards

Markus Wanner