Horton

Re: Function to promote standby servers

Laurenz Albe <laurenz.albe@cybertec.at>

View thread View on postgr.es
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ashwin Agrawal <aagrawal@pivotal.io>
Cc: michael@paquier.xyz, Masahiko Sawada <sawada.mshk@gmail.com>, PostgreSQL mailing lists <pgsql-hackers@postgresql.org>
Date: 2018-10-16T07:49:20Z
Lists: pgsql-hackers 
Ashwin Agrawal wrote:
> Just curious to know, is promotion via function only allowed for
> hot-standby or works for any standby?

Only for hot standby - how do you want to execute a function on a standby
server that doesn't allow connections?

Yours,
Laurenz Albe

Commits

  1. Rework documentation of pg_promote

  2. Add pg_promote function