Justin Clift jc
Mon Aug 2 10:26:00 PDT 2004
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?

Regards and best wishes,

Justin Clift



More information about the Slony1-general mailing list