Re: [GENERAL] pg_basebackup issue - Mailing list pgsql-general

From chiru r
Subject Re: [GENERAL] pg_basebackup issue
Date
Msg-id CA+RSxMhEgqaSQCF_W2TnKEahP59toV+zn8wrWaFHBfZ6spujYw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] pg_basebackup issue  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: [GENERAL] pg_basebackup issue  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Use case: Want to control database privileges/default roles by creating roles instead of granting directly to users.
So that we can manage database access control easily.

Thanks,
Chiru

On Sat, Apr 22, 2017 at 10:03 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Saturday, April 22, 2017, chiru r <chirupg@gmail.com> wrote:
Thank you Adrian.

It seems the code is allowing only who has Superuser/Replication role directly.

Is there any possibility in future releases they allow both case A & B  Users able to  use pg_basebackup.


It does not seem wise to introduce inheritance of such powerful capabilities when for many years now we have not done so.  It seems like reality could be better documented but the present behavior should stay.  I also find the original choice to be quite sane regardless.

David J.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] pg_basebackup issue
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] pg_basebackup issue