Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. - Mailing list pgsql-hackers

On 2021-Oct-25, Jeff Davis wrote:

> But CHECKPOINT right now has an explicit superuser check, and it would
> be nice to be able to avoid that.
> 
> It's pretty normal to issue a CHECKPOINT right after a data load and
> before running a performance test, right? Shouldn't there be some way
> to do that without superuser?

Maybe you just need pg_checkpointer.

-- 
Álvaro Herrera              Valdivia, Chile  —  https://www.EnterpriseDB.com/