Re: pg_system_identifier()

From: bricklen <bricklen(at)gmail(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: Vik Fearing <vik(dot)fearing(at)dalibo(dot)com>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_system_identifier()
Date: 2013-08-22 14:47:50
Message-ID: CAGrpgQ-CddnmVYESBpYxGTJZNMP+MhVfgPC-dpDB1QU-v98qAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Aug 22, 2013 at 6:42 AM, Andres Freund <andres(at)2ndquadrant(dot)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/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Blake Smith 2013-08-22 14:55:45 Hstore: Query speedups with Gin index
Previous Message Andres Freund 2013-08-22 13:42:05 Re: pg_system_identifier()