Re: new createuser option for replication role
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-09-10T14:50:13Z
Lists: 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