Re: pgsql: Switch TAP tests of pg_rewind to use a role with minimalpermiss

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