On 04/23/2017 04:52 AM, chiru r wrote:
Thank you for your reply. I agree, However we are planning, users not to have any direct privileges on database objects or default roles(like SUPERUSER,CREATEDB,REPLICATION..etc) in postgres. looking to create users(LOGIN) only and Grant all the privileges through roles like below. *Steps: * Create User Create role GRANT required privileges/default attributes(SUPERUSER,REPLICATION etc) to Role GRANT role to Users. So,If I follow above process I am not able to do pg_basebackup. Now I have only options left either I have to use postgres user or create a user directly with replication role(Which we are not interested in). In future is there possibility to allow a user(using above steps) to do pg_basebackup?.
That would be a Postgres developer question/answer. Many of the developers are on this list and may respond at some point. If you want to put the question directly to the developers I would suggest either:
1) Posting to --hackers (https://www.postgresql.org/list/pgsql-hackers/) 2) Filing a bug report: https://www.postgresql.org/account/login/?next=/account/submitbug/
Thanks, Chiru
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
