Horton

Re: Function to promote standby servers

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Ashwin Agrawal <aagrawal@pivotal.io>, Masahiko Sawada <sawada.mshk@gmail.com>, PostgreSQL mailing lists <pgsql-hackers@postgresql.org>
Date: 2018-10-18T23:56:20Z
Lists: pgsql-hackers 
On Tue, Oct 16, 2018 at 09:49:20AM +0200, Laurenz Albe wrote:
> Only for hot standby - how do you want to execute a function on a standby
> server that doesn't allow connections?

In most deployments hot standby will be enabled, and wal_level uses the
same value for archive and hot_standby for some time now, so that does
not sound like a huge issue to me. 
--
Michael

Commits

  1. Rework documentation of pg_promote

  2. Add pg_promote function