416784 - In PostgreSQL 8.1 and newer, createuser takes the argument -R instead of -A

Status: RESOLVED FIXED

(Bugzilla :: Documentation, defect)

Description

[philip.gillissen]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12
Build Identifier: 

The documentation about creating a user in PostgreSQL has a little mistake. It says:
>As the postgres user, you then need to create a new user:
> bash$ createuser -U postgres -dAP bugs
The flag -A does not exist. In my opinion, it should be -R.

Reproducible: Always

Comment 1

[Emmanuel Seyman]

I'm using Pg 8.2.6 and the createuser command does have a "-A" flag.
This allows you to create a user who doesn't have the ability to create other
users.

Comment 2

[philip.gillissen]

Uhm... oke, I'm using Pg 8.1.3 and there's no option -A.
The option to not allow creating roles is called -R.[1] Probably, a annotation to this flag should be inserted in the documentation.

[1] http://www.postgresql.org/docs/8.1/interactive/app-createuser.html

Comment 3

[Frédéric Buclin]

Pg 8.0 uses -A:

http://www.postgresql.org/docs/8.0/interactive/app-createuser.html

Pg 8.2 (replace 8.0 by 8.2 in the URL above) seems to use -R, but maybe -A is still functional for backward compatibility.

Comment 4

[philip.gillissen]

In my version, it doesn't work. Is there anyone else with this problem?
Otherwise, this bug can be closed.

Comment 5

[Frédéric Buclin]

OK, I checked in all versions since Pg 8.0, and Pg 8.0 is the last one to use -A. In 8.1 and newer, -A has been replaced by -R (and -A has indeed no effect; you get a prompt asking you if you want to let the new user create roles). Pg 8.1 and newer also accept the -S argument, which means "The new user will not be a superuser."; else you get a prompt asking you whether it should.

So in Pg 8.0, we need: -dAP
But in Pg 8.1 and newer, we need: -dRSP (I tested with Pg 8.4.5 and 9.0.1)

Bugzilla 4.1 requires Pg 8.3, so we don't need to mention -dAP. But Bugzilla 4.0 and older (back to 3.0) require Pg 8.0, so we need to mention both.

Comment 6

[Frédéric Buclin]

Attachment: patch, v1

The note is only for Bugzilla 4.0 and older. For trunk, it's not needed (I will remove it on checkin).

Comment 7

[Emmanuel Seyman]

Comment on attachment 492397 [details] [diff] [review]
patch, v1

No problem here.

Comment 8

[Frédéric Buclin]

Committing to: bzr+ssh://[e-mail]/bugzilla/trunk/
modified docs/en/xml/installation.xml
Committed revision 7608.

Committing to: bzr+ssh://[e-mail]/bugzilla/4.0/
modified docs/en/xml/installation.xml
Committed revision 7487.

Committing to: bzr+ssh://[e-mail]/bugzilla/3.6/
modified docs/en/xml/installation.xml
Committed revision 7211.

Committing to: bzr+ssh://[e-mail]/bugzilla/3.4/
modified docs/en/xml/installation.xml
Committed revision 6785.

Committing to: bzr+ssh://[e-mail]/bugzilla/3.2/
modified docs/en/xml/installation.xml
Committed revision 6406.