Hi Ricardo,
Attached are the files you asked for. Files may be used for a cluster
with two nodes. Such files should be placed on one node, and similar files
(change only the main reference name in each of them) for the second node.
Additional in "pgcluster.conf" file specify: listen_addresses = '*'
Remember to add in etc/hosts on each node:
IP1 rep1 lb1 debian1
IP2 rep2 lb2 debian2
Execute initdb script on each node, and then start pgReplicator services
in the following order (suppose postgres was installed in usr/local/pgsql
default folder):
Node 1:
cd /usr/local/pgsql/bin
pg_ctl -D /usr/local/pgsql/data -o "-i" start
pgreplicate -D /usr/local/pgsql/etc
Node 2:
pg_ctl -D /usr/local/pgsql/data -o "-i -U" start
pgreplicate -D /usr/local/pgsql/etc
pglb -D /usr/local/pgsql/etc
Node1:
pglb -D /usr/local/pgsql/etc -n -v
Then you may connect from your application to IP1:5433 (LB1) or IP2:5433
(LB2).
Hint: use sometimes "-n -v" (verbose,and not background thread) for
replication and load-balancer services, for debug purposes.
First DB node is considered "master" only by the time the "recovery"
process runs. For the rest of the time, the 2 nodes are equally used through
the load-balancing services.
Hope this is useful.
Have a nice day,
Lia
_____
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ricardo da
Silva
Sent: 05 May 2008 16:35
To: [email protected]
Subject: [Pgcluster-general] PgCluster share with us the conf's
Hi, Lia
Please ,share your .conf ,the test that you did with us two nodes
cluster.conf
pgreplication.conf
pglb.conf
could explain the scenario that you did?
I am trying to make a cluster of storage
thks
pgCluster.tar.gz
Description: GNU Zip compressed data
_______________________________________________ Pgcluster-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgcluster-general
