Hi !

What you can do to overtook this problem is to store the host name in the
comment field when creating your node:

store node (id=3D1, comment=3D'some_host_name');

Then you just have to query sl_node table depending what you are looking
for:

select no_id from _clustername.sl_node where no_comment=3D'some_host_name';
or
select no_comment from _clustername.sl_node where no_id =3D 1;

Trust me, it helps a lot ;) ;)

michael

On Fri, Oct 3, 2008 at 12:28 AM, Christopher Browne <
cbbrowne at ca.afilias.info> wrote:

> 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=3D"cbbrowne" and tld=3D"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/>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20081003/=
8b01dcbd/attachment-0001.htm