Re: Database system identifier via SELECT?

On Thu, Dec 8, 2011 at 4:27 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> Joshua D. Drake wrote:
> >
> > 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().
>

select inet_server_addr()?

--Scott

> >
> > This seems like something we should have in core, don't you think?
>
> Yeah, kind of, except this is the first request we ever got for this.
> The identifier is passed as part of streaming replication, so maybe it
> will be needed more in the future.
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + It's impossible for everything to be true. +
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>