On 8/2/2004 6:22 AM, Justin Clift wrote:
> Hi all,
> 
> Out of curiosity, when I connect to a Slony database from a multi-homed 
> system (multiple IP addresses each with a different name), how do I know 
> which node I'm connected to?
> 
> Initial thought was to pass the sl_path.pa_conninfo field and work it 
> out that way, but that fails for the above scenario where the conninfo 
> string may not match the hostname.
> 
> If there's no other easier way, could we make this bit a bunch easier by 
> creating a table/view (call it sl_info for example) that says explicitly 
> which node we're on?

There's a function, getLocalNodeId()


Jan

> 
> Regards and best wishes,
> 
> Justin Clift
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #