On 12/08/2011 12:57 PM, Bruce Momjian wrote:
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().
This seems like something we should have in core, don't you think?
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
