Database system identifier via SELECT?

From: Chris Redekop <chris(at)replicon(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Database system identifier via SELECT?
Date: 2011-12-08 18:08:31
Message-ID: CAC2SuRJLMtKyvCs6DbxdyUrHy+WKe-94cBuGnwCXAg914cwG7g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2011-12-08 18:14:36 Re: Hope for a new PostgreSQL era?
Previous Message Tomas Vondra 2011-12-08 17:48:13 Re: Hope for a new PostgreSQL era?