Re: Postgres-R

Thanks for the information.
For Step5 (starting ensemble daemon).-
I set the multicast address to both nodes (Node 1& Node 2 eth0: 224.0.0.9/4) before starting the ensemble. And started the server application mtalk in node 1 & node 2 and then client application in node 1 & node 2. But the count of members ('nmembers') show as 1. This is the output of the client program 'c_mtalk'. Seeing this, I'am assuming that the applications are not merged.
Could you please let me know how did you proceed with the setup of ensemble?

regards,
Niranjan

-----Original Message-----
From: ext leiyonghua [mailto:leiyonghua(at)alibaba-inc(dot)com]
Sent: Monday, August 18, 2008 2:58 PM
To: K, Niranjan (NSN - IN/Bangalore); Markus Wanner; pgsql-hackers(at)postgresql(dot)org
Subject: Re: Postgres-R

niranjan(dot)k(at)nsn(dot)com 写道:
> I wish to set up the Postgres-R environment, could you please let me know the steps for setting it up.
> Thanks.
>
>
>
yeah, actually, i have not been successful to set up this, but let me give some information for you.
1. download the postgresql snapshot source code from here:
http://www.postgresql.org/ftp/snapshot/dev/
(this is a daily tarball)

2. Get the corresponding patch for postgres-r from:
http://www.postgres-r.org/downloads/

3. apply the patch for snapshot source, and configure like this:

./configure --enable-replication
make & make install

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)

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;

Hope information above would be helpful, and keep in touch.

leiyonghua