diff options
Diffstat (limited to 'doc/man/createdb.1')
-rw-r--r-- | doc/man/createdb.1 | 127 |
1 files changed, 127 insertions, 0 deletions
diff --git a/doc/man/createdb.1 b/doc/man/createdb.1 new file mode 100644 index 00000000000..832cc39dff8 --- /dev/null +++ b/doc/man/createdb.1 @@ -0,0 +1,127 @@ +.\" This is -*-nroff-*- +.\" XXX standard disclaimer belongs here.... +.\" $Header: /cvsroot/pgsql/doc/man/Attic/createdb.1,v 1.1.1.1 1996/08/18 22:14:22 scrappy Exp $ +.TH CREATEDB UNIX 11/05/95 Postgres95 Postgres95 +.SH NAME +createdb \(em create a database +.SH SYNOPSIS +.BR createdb +[\c +.BR -a +system] +[\c +.BR -h +host] +[\c +.BR -p +port] +[dbname] +.SH DESCRIPTION +.IR Createdb +creates a new database. The person who executes this command becomes +the database administrator, or DBA, for this database and is the only +person, other than the Postgres super-user, who can destroy it. +.PP +.IR Createdb +is a shell script that invokes +.IR psql . +Hence, a +.IR postmaster +process must be running on the database server host before +.IR createdb +is executed. In addition, the +.SM PGOPTION +and +.SM PGREALM +environment variables will be passed on to +.IR psql +and processed as described in +.IR psql (1). +.PP +The optional argument +.IR dbname +specifies the name of the database to be created. The name must be +unique among all Postgres databases. +.IR Dbname +defaults to the value of the +.SM USER +environment variable. +.PP +.IR Createdb +understands the following command-line options: +.TP 5n +.BR "-a" " system" +Specifies an authentication system +.IR "system" +(see +.IR introduction (1)) +to use in connecting to the +.IR postmaster +process. The default is site-specific. +.TP +.BR "-h" " host" +Specifies the hostname of the machine on which the +.IR postmaster +is running. Defaults to the name of the local host, or the value of +the +.SM PGHOST +environment variable (if set). +.TP +.BR "-p" " port" +Specifies the Internet TCP port on which the +.IR postmaster +is listening for connections. Defaults to 5432, or the value of the +.SM PGPORT +environment variable (if set). +.SH EXAMPLES +.nf +# create 5432 demo database +createdb demo +.fi +.nf +# create the demo database using the postmaster on host eden, +# port using the Kerberos authentication system. +createdb -a kerberos -p 5432 -h eden demo +.fi +.SH FILES +.TP 5n +\&$PGDATA/base/\fIdbname\fP +The location of the files corresponding to the database +.IR dbname . +.SH "SEE ALSO" +createdb(l), +destroydb(1), +initdb(1), +psql(1), +postmaster(1). +.SH DIAGNOSTICS +.TP 5n +.BI "Error: Failed to connect to backend (host=" "xxx" ", port=" "xxx" ")" +.IR Createdb +could not attach to the +.IR postmaster +process on the specified host and port. If you see this message, +ensure that the +.IR postmaster +is running on the proper host and that you have specified the proper +port. If your site uses an authentication system, ensure that you +have obtained the required authentication credentials. +.TP +.BI "user \*(lq" "username" "\*(rq is not in \*(lqpg_user\*(rq" +You do not have a valid entry in the relation \*(lqpg_user\*(rq and +cannot do anything with Postgres at all; contact your Postgres site +administrator. +.TP +.BI "user \*(lq" "username" "\*(rq is not allowed to create/destroy databases" +You do not have permission to create new databases; contact your Postgres +site administrator. +.TP +.IB "dbname" " already exists" +The database already exists. +.TP +.BI "database creation failed on" " dbname" +An internal error occurred in +.IR psql +or the backend server. Ensure that your Postgres site administrator has +properly installed Postgres and initialized the site with +.IR initdb . |