-----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Bruce Momjian Sent: Thursday, December 08, 2011 3:57 PM To: Chris Redekop Cc: pgsql-general Subject: Re: Database system identifier via SELECT? Chris Redekop wrote: > Is there any way to get the database system identifier via a select > statement? I have a primary/secondary async replication setup, and > I'd like be able to verify from the client side that the provided > primary and secondary connection strings do in fact refer to the same data set... Wow, that is a reasonable thing to want available via SQL, but I can't see a way to get to it. The only method I can suggest is to write a server-side C function that calls GetSystemIdentifier(). --------------------------------------------------- Maybe I mis-understand the question but how about: SHOW listen_addresses; (of the functional equivalent) You just need to make sure each server is listening to a specific IP and/or Port and just tag off of that. David J. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
