Re: [Patch] New psql prompt substitution %r (m = master, r = replica) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [Patch] New psql prompt substitution %r (m = master, r = replica)
Date
Msg-id 21582.1470930690@sss.pgh.pa.us
Whole thread Raw
In response to Re: [Patch] New psql prompt substitution %r (m = master, r = replica)  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: [Patch] New psql prompt substitution %r (m = master, r = replica)  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> On 8/11/16 6:04 AM, Aleksander Alekseev wrote:
>> Suggested patch introduces an %r substitution in psql's prompt. This
>> substitution allows to display whether user is connected to master or
>> replica right in a prompt.

> In the near future, there will (probably) be a lot more variants about
> what it means to be a master or a replica.  There will be logical
> replication, where you could be a publisher of something and a consumer
> of something else.  You could even be a logical consumer but a physical
> master.  So a global binary facility is probably not very forward
> looking and will lead to confusion.

Also, the patch as given is broken since it fails to account for the
server being promoted while a psql session is open.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [Patch] New psql prompt substitution %r (m = master, r = replica)
Next
From: Jeff Janes
Date:
Subject: Re: new autovacuum criterion for visible pages