Daniel B. Thurman wrote:
Thanks for some details and it helps, except the following step:
10) Create Paths on the master to both slaves, and on each slave back to
the master. Create the paths under each node on the master, using
the connection strings specified in the slon config files. Note that
future restructuring of the cluster may require additional paths to
be defined.
Can you please elaborate?
I am not clear if by "master" you mean "master server" or "master node"
and likewise for "slave" you mean "slave server" or "slave node".
Technically node (or database). That tutorial was written using a single
server which is stated at the beginning so there is no master or slave
server.
It is not clear if I need only to update the paths only on the
master-server and if any work needs to be done for the paths on
the slave-servers.
Check the slony docs for more info on paths, but essentially you need
paths on each node pointing to every other node it might talk to. So in
the example given, the master has paths to both slaves, and each slave
has a path to the master. If you restructure the cluster, and make a
slave the master, you will need to add a path on that node to the
remaining slave, and on the remaining slave to the new master.
Regards, Dave
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
