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

From Jeff Davis
Subject Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.
Date
Msg-id c5d7045507b0ccac7d9421f52bf3b59b60e1150b.camel@j-davis.com
Whole thread Raw
In response to Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.
List pgsql-hackers
On Mon, 2021-11-08 at 12:47 -0500, Stephen Frost wrote:
> 
> I don't feel as strongly as others apparently do on this point
> though,
> and I'd rather have non-superusers able to run CHECKPOINT *somehow*
> than not, so if the others feel like a predefined role is a better
> approach then I'm alright with that.  Seems a bit overkill to me but
> it's also not like it's actually all that much code or work to do.

+1. It seems like the pg_checkpointer predefined role is the most
acceptable to everyone (even if not universally liked).

Attached a rebased version of that patch.

Regards,
    Jeff Davis


Attachment

pgsql-hackers by date:

Previous
From: Greg Nancarrow
Date:
Subject: Re: Failed transaction statistics to measure the logical replication progress
Next
From: Michael Paquier
Date:
Subject: Improve error context after some failed XLogReadRecord()