kevin kempter <kevin at kevinkempterllc.com> writes:
> If I look at the slony schema tables on a node within a replication
> cluster, where do I look to determine the node_id's and respective
> server names for the nodes in the cluster ?

On each node, you call the stored function
GetLocalNodeID(cluster_name), passing in the name of the cluster
(e.g. - '_mycluster', or such); that identifies the node number for a
given database.

The host name is not actually stored anywhere; what *is* stored are
the paths required for particular slons to connect to particular
servers, as stored in the table sl_path.
-- 
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
http://cbbrowne.com/info/multiplexor.html
Rules  of the  Evil Overlord  #202. "All  crones with  the  ability to
prophesy  will be  given  free facelifts,  permanents, manicures,  and
Donna  Karan   wardrobes.  That  should  pretty   well  destroy  their
credibility." <http://www.eviloverlord.com/>