Re: [Patch] New psql prompt substitution %r (m = master, r = replica)

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Aleksander Alekseev <a(dot)alekseev(at)postgrespro(dot)ru>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [Patch] New psql prompt substitution %r (m = master, r = replica)
Date: 2016-08-11 15:45:19
Message-ID: 4b3b4e12-0647-1c91-e1e9-820529877549@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-08-11 15:51:30 Re: [Patch] New psql prompt substitution %r (m = master, r = replica)
Previous Message Tom Lane 2016-08-11 15:35:24 Re: No longer possible to query catalogs for index capabilities?