Re: pg_system_identifier() - Mailing list pgsql-hackers

From bricklen
Subject Re: pg_system_identifier()
Date
Msg-id CAGrpgQ-CddnmVYESBpYxGTJZNMP+MhVfgPC-dpDB1QU-v98qAQ@mail.gmail.com
Whole thread
In response to Re: pg_system_identifier()  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: pg_system_identifier()
List pgsql-hackers

On Thu, Aug 22, 2013 at 6:42 AM, Andres Freund <andres@2ndquadrant.com> wrote:

FWIW I've wished for that function repeatedly. Mostly just to make sure
I am actually connected to the same "network" of replicas and not some
other.
It's also useful if you're providing support for a limited number of
machines and you want some form of identifying a node.

There's a "hostname" function at PGXN which serves some use-cases: http://pgxn.org/dist/hostname/

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pg_system_identifier()
Next
From: Blake Smith
Date:
Subject: Hstore: Query speedups with Gin index