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(). -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
