Postgres Pro
Downloads
Home   >   mailing lists

Re: Database system identifier via SELECT? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Database system identifier via SELECT?
Date
Msg-id 201112082057.pB8KvOU19242@momjian.us
Whole thread Raw
In response to Database system identifier via SELECT?  (Chris Redekop <chris@replicon.com>)
Responses Re: Database system identifier via SELECT?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Database system identifier via SELECT?  ("David Johnston" <polobo@yahoo.com>)
List pgsql-general
Tree view 
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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Clarification on CONTEXT: xlog redo xid assignment
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Database system identifier via SELECT?