Re: new createuser option for replication role - Mailing list pgsql-hackers

From Tom Lane
Subject Re: new createuser option for replication role
Date
Msg-id 1061.1315666213@sss.pgh.pa.us
Whole thread Raw
In response to new createuser option for replication role  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: new createuser option for replication role
List pgsql-hackers
Fujii Masao <masao.fujii@gmail.com> writes:
> Currently createuser cannot create a role with REPLICATION privilege
> because it doesn't have any option to do that. Which sometimes annoys
> me when setting up replication. I'd like to propose to add new options
> "-x (--replication)" and "-X (--no-replication)" into createuser. "-x" allows
> the new user to do replication, and "-X" disallows. The default is "-X".
> Is it worth creating the patch?

> Though I'd like to use "-r" and "-R" as the option name, they have already
> been used for CREATEROLE privilege. So I'm thinking to use "-x" and
> "-X" derived from XLOG. But does anyone have better option name?

Better solution: don't have a short form of the switch.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: 9.1rc1 bug: extension types not dropped with DROP SCHEMA CASCADE
Next
From: Alexey Klyukin
Date:
Subject: Re: REVIEW proposal: a validator for configuration files