Horton

Re: Reducing power consumption on idle servers

Thomas Munro <thomas.munro@gmail.com>

View thread View on postgr.es
From: Thomas Munro <thomas.munro@gmail.com>
To: Simon Riggs <simon.riggs@enterprisedb.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, Andres Freund <andres@anarazel.de>, Zheng Li <zhengli10@gmail.com>, Jim Nasby <nasbyj@amazon.com>, Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2022-11-20T21:13:06Z
Lists: pgsql-hackers

Attachments

On Mon, Nov 21, 2022 at 3:35 AM Simon Riggs
<simon.riggs@enterprisedb.com> wrote:
> On Sat, 19 Nov 2022 at 10:59, Simon Riggs <simon.riggs@enterprisedb.com> wrote:
> > New version attached.
>
> Fix for doc xref

I removed a stray variable declaration from xlogrecovery.h, and wrote
a draft commit message.  I'll wait 24 hours before committing, to
provide a last chance for anyone who wants to complain about dropping
promote_trigger_file.

(We could of course change it so that the timeout based wakeup only
happens if you have actually set promote_trigger_file, but I think
we've established that we just don't want the filesystem polling
feature so I'm whispering this in parentheses.)

Commits

  1. Remove promote_trigger_file.

  2. Add pg_promote function

  3. pg_ctl promote