Re: pgsql: Switch TAP tests of pg_rewind to use a role with minimalpermiss - Mailing list pgsql-committers

From Andrew Dunstan
Subject Re: pgsql: Switch TAP tests of pg_rewind to use a role with minimalpermiss
Date
Msg-id 3cd43d33-f415-cc41-ade3-7230ab15b2c9@2ndQuadrant.com
Whole thread Raw
In response to pgsql: Switch TAP tests of pg_rewind to use a role with minimalpermiss  (Michael Paquier <michael@paquier.xyz>)
Responses Re: pgsql: Switch TAP tests of pg_rewind to use a role with minimal permiss  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
On 4/11/19 9:56 PM, Michael Paquier wrote:
> Switch TAP tests of pg_rewind to use a role with minimal permissions
>
> Up to now the tests of pg_rewind have been using a superuser for all the
> tests (which is the default of many tests actually, and something that
> ought to be reviewed) when involving an online source server, still it
> is possible to use a non-superuser role to do that as long as this role
> is granted permissions to execute all the source-side functions used for
> the rewind.  This is possible since v11, and was already documented as
> of bfc8068.
>
> This will allow to catch up easily any change in pg_rewind if the tool
> begins to use more backend-side functions, so as the properties
> introduced by v11 are kept.
>


jacana and bowerbird don't seem happy with this.


cheers


andrew


-- 

Andrew Dunstan                https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services




pgsql-committers by date:

Previous
From: Magnus Hagander
Date:
Subject: pgsql: Show shared object statistics in pg_stat_database
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Switch TAP tests of pg_rewind to use a role with minimal permiss