This text was automatically converted from troff me macros to HTML. Information may have been lost, added, or changed in the process. Lars Aronsson and Lysator do not guarantee the correctness of this HTML document.
createuser *- create a POSTGRES user
createuser [-p port] [-h host] username
Createuser creates a new POSTGRES user. Only users with ``usesuper'' set in the pg_user class can create new POSTGRES users. As shipped, the user ``postgres'' can create users.
Username is the name of the POSTGRES user to be created. The name must be unique among all POSTGRES users.
The arguments port and hostname are the same as in the terminal monitor - they are used to connect to the postmaster using the TCP/IP port port running on the database server hostname. The defaults are to the local machine (localhost) and to the default port (4321).
Once invoked with the above options createuser will guide the person adding the new POSTGRES user through a series of questions. These questions describe the security capabilities of the POSTGRES user. The new user's POSTGRES userid must be the user's Unix userid.
destroyuser(unix).
You are not a valid POSTGRES user
You do not have a users file entry, and can not do anything with POSTGRES at all.
<user> already exists
The user already exists.
POSTGRES userid's and usernames should not have anything to do with the constraints of UNIX.