Re: - Mailing list pgadmin-support

From Dave Page
Subject Re:
Date
Msg-id 46FCBDE5.8050009@postgresql.org
Whole thread Raw
In response to  ("Daniel B. Thurman" <dant@cdkkt.com>)
List pgadmin-support
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


pgadmin-support by date:

Previous
From: Kieran McCusker
Date:
Subject: Bug in pgadmin table properties (tested on Beta 5)
Next
From: Kieran McCusker
Date:
Subject: Feature request in pgadmin (tested on Beta 5)