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: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>, Ian Lawrence Barwick <barwick@gmail.com>, Laurenz Albe <laurenz.albe@cybertec.at>, Simon Riggs <simon.riggs@enterprisedb.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>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2022-11-28T23:15:53Z
Lists: pgsql-hackers 
I found some more comments and some documentation to word-smith very
lightly, and pushed.  The comments were stray references to the
trigger file.  It's
a little confusing because the remaining mechanism also uses a file,
but it uses a signal first so seems better to refer to promotion
requests rather than files.

/me wonders how many idle servers there are in the world

Commits

  1. Remove promote_trigger_file.

  2. Add pg_promote function

  3. pg_ctl promote