Switch TAP tests of pg_rewind to use role with only functionpermissions

Поиск
Список
Период
Сортировка
Искать
От
Michael Paquier
Тема
Switch TAP tests of pg_rewind to use role with only functionpermissions
Дата
Msg-id
20190411041336.GM2728@paquier.xyz
Список
Дерево обсуждения
Switch TAP tests of pg_rewind to use role with only functionpermissions Michael Paquier <michael@paquier.xyz>
Re: Switch TAP tests of pg_rewind to use role with only function permissions Magnus Hagander <magnus@hagander.net>
Re: Switch TAP tests of pg_rewind to use role with only functionpermissions Michael Paquier <michael@paquier.xyz>
Hi all,

Recent commit bfc80683 has added some documentation in pg_rewind about
the fact that it is possible to do the operation with a non-superuser,
assuming that this role has sufficient grant rights to execute the
functions used by pg_rewind.

Peter Eisentraut has suggested to have some tests for this kind of
user here:
https://www.postgresql.org/message-id/e1570ba6-4459-d9b2-1321-9449adaaef4c@2ndquadrant.com

Attached is a patch which switches all the TAP tests of pg_rewind to
do that.  As of now, the tests depend on a superuser for everything,
and it seems to me that it makes little sense to make the tests more
pluggable by being able to switch the roles used on-the-fly (the
invocation of pg_rewind is stuck into RewindTest.pm) as a superuser
has no restrictions.

Any thoughts?
--
Michael
В списке pgsql-hackers по дате отправления
От: Mark Kirkwood
Дата:
От: Michael Paquier
Дата:
Сообщение: Re: pg_rewind vs superuser
FAQ