Horton

Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Andres Freund <andres@anarazel.de>, Stephen Frost <sfrost@snowman.net>, "Bossart, Nathan" <bossartn@amazon.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2021-11-05T12:42:58Z
Lists: pgsql-hackers 
On Thu, Nov 4, 2021 at 7:38 PM Jeff Davis <pgsql@j-davis.com> wrote:
> It seems like this specific approach has been mostly shot down already.
>  But out of curiosity, are you intending to run CHECKPOINT during
> bootstrap or something?

Imagine a system with corruption in pg_proc. Right now, that won't
prevent you from successfully executing a checkpoint. With this
approach, it might.

-- 
Robert Haas
EDB: http://www.enterprisedb.com

Commits

  1. Add pg_checkpointer predefined role for CHECKPOINT command.