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

From: Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>, pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Switch TAP tests of pg_rewind to use a role with minimal permiss
Date: 2019-04-13 02:05:06
Message-ID: 3cd43d33-f415-cc41-ade3-7230ab15b2c9@2ndQuadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2019-04-13 02:59:23 Re: pgsql: Switch TAP tests of pg_rewind to use a role with minimal permiss
Previous Message Magnus Hagander 2019-04-12 12:13:29 pgsql: Show shared object statistics in pg_stat_database