Re: Database system identifier via SELECT?

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Bruce Momjian
Sent: Thursday, December 08, 2011 3:57 PM
To: Chris Redekop
Cc: pgsql-general
Subject: Re: [GENERAL] 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.