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

Поиск
Список
Период
Сортировка
Искать
От
Jeff Davis
Тема
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.
Дата
Msg-id
c5d7045507b0ccac7d9421f52bf3b59b60e1150b.camel@j-davis.com
Ответ на
Список
Дерево обсуждения
Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Robert Haas <robertmhaas@gmail.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Vik Fearing <vik@postgresfriends.org>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Vik Fearing <vik@postgresfriends.org>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Isaac Morland <isaac.morland@gmail.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. "David G. Johnston" <david.g.johnston@gmail.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Isaac Morland <isaac.morland@gmail.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Tom Lane <tgl@sss.pgh.pa.us>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Mark Dilger <mark.dilger@enterprisedb.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. "David G. Johnston" <david.g.johnston@gmail.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. "Bossart, Nathan" <bossartn@amazon.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. "Bossart, Nathan" <bossartn@amazon.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. "Bossart, Nathan" <bossartn@amazon.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. "Bossart, Nathan" <bossartn@amazon.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Andres Freund <andres@anarazel.de>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Robert Haas <robertmhaas@gmail.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Andres Freund <andres@anarazel.de>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Andres Freund <andres@anarazel.de>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. "Bossart, Nathan" <bossartn@amazon.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. "Bossart, Nathan" <bossartn@amazon.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Robert Haas <robertmhaas@gmail.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Andres Freund <andres@anarazel.de>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Jeff Davis <pgsql@j-davis.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Robert Haas <robertmhaas@gmail.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Andres Freund <andres@anarazel.de>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Robert Haas <robertmhaas@gmail.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Daniel Gustafsson <daniel@yesql.se>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. "Bossart, Nathan" <bossartn@amazon.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. Stephen Frost <sfrost@snowman.net>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. "Bossart, Nathan" <bossartn@amazon.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. "Bossart, Nathan" <bossartn@amazon.com>
Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT. "Bossart, Nathan" <bossartn@amazon.com>
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

В списке pgsql-hackers по дате отправления
От: Greg Nancarrow
Дата:
От: Michael Paquier
Дата:
FAQ