Re: pg_system_identifier() - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: pg_system_identifier()
Date
Msg-id CAHGQGwHN0114tzFnV2e3Pk8L74vHmDjPk7g73woK9B7xirT5pw@mail.gmail.com
Whole thread Raw
In response to pg_system_identifier()  (Vik Fearing <vik.fearing@dalibo.com>)
Responses Re: pg_system_identifier()  (Vik Fearing <vik.fearing@dalibo.com>)
Re: pg_system_identifier()  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On Thu, Aug 22, 2013 at 6:43 AM, Vik Fearing <vik.fearing@dalibo.com> wrote:
> After someone in IRC asked if there was an equivalent to MySQL's
> server_id, it was noted that we do have a system identifier but it's not
> very accessible.
>
> The attached patch implements a pg_system_identifier() function that
> exposes it.

What's the use case?

IIUC, PostgreSQL's system identifier is not equal to MySQL server-id.
In PostgreSQL, in replication, the master and all the standbys must
have the same system identifier. OTOH, in MySQL, they have the different
server-ids. No?

Regards,

-- 
Fujii Masao



pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: PL/pgSQL, RAISE and error context
Next
From: Vik Fearing
Date:
Subject: Re: pg_system_identifier()