1 .\" This is -*-nroff-*-
2 .\" XXX standard disclaimer belongs here....
3 .\" $Header: /cvsroot/pgsql/src/man/Attic/createuser.1,v 1.6 1998/01/26 01:42:44 scrappy Exp $
4 .TH CREATEUSER UNIX 11/05/95 PostgreSQL PostgreSQL
6 createuser - create a Postgres user
21 creates a new Postgres user. Only users with \*(lqusesuper\*(rq set in
22 the \*(lqpg_user\*(rq class can create new Postgres users. As shipped,
23 the user \*(lqpostgres\*(rq can create users.
26 is a shell script that invokes
30 process must be running on the database server host before
32 is executed. In addition, the
37 variables will be passed on to
39 and processed as described in
44 specifies the name of the Postgres user to be created. (The invoker will
45 be prompted for a name if none is specified on the command line.)
46 This name must be unique among all Postgres users.
49 understands the following command-line options:
52 Specifies an authentication system
56 to use in connecting to the
58 process. This option no longer has any effect.
61 Specifies the hostname of the machine on which the
63 is running. Defaults to using local Unix domain sockets.
66 Specifies the TCP/IP port or local Unix domain socket file
67 extension on which the
69 is listening for connections. Defaults to 5432, or the value of the
71 environment variable (if set).
72 .SH "INTERACTIVE QUESTIONS"
73 Once invoked with the above options,
75 will ask a series of questions. The new users's login name (if not
76 given on the command line) and user-id must be specified. (Note that
77 the Postgres user-id must be the same as the user's Unix user-id.) In
78 addition, you must describe the security capabilities of the new user.
79 Specifically, you will be asked whether the new user should be able to
80 act as Postgres super-user, create new databases and update the system
88 .BI "Error: Failed to connect to backend (host=" "xxx" ", port=" "xxx" ")"
90 could not attach to the
92 process on the specified host and port. If you see this message,
95 is running on the proper host and that you have specified the proper
96 port. If your site uses an authentication system, ensure that you
97 have obtained the required authentication credentials.
99 .BI "user \*(lq" "username" "\*(rq is not in \*(lqpg_user\*(rq"
100 You do not have a valid entry in the relation \*(lqpg_user\*(rq and
101 cannot do anything with Postgres at all; contact your Postgres site
104 .IB "username" " cannot create users."
105 You do not have permission to create new users; contact your Postgres
108 .BI "user \*(lq" "username" "\*(rq already exists"
109 The user to be added already has an entry in the \*(lqpg_user\*(rq
112 .BR "database access failed"
113 An internal error occurred in
115 or the backend server. Ensure that your Postgres site administrator has
116 properly installed Postgres and initialized the site with
119 Postgres user-ids and user names should not have anything to do with the