File: app-destroydb.html

package info (click to toggle)
mpsql 2.1-2
links: PTS
area: non-free
in suites: potato
size: 3,528 kB
ctags: 4,886
sloc: ansic: 35,184; makefile: 3,761; sh: 44
file content (549 lines) | stat: -rw-r--r-- 8,195 bytes
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML
><HEAD
><TITLE
>destroydb</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet version 1.19"><LINK
REL="HOME"
TITLE="PostgreSQL User's Guide"
HREF="user.html"><LINK
REL="UP"
TITLE="Utility Applications"
HREF="utilities.html"><LINK
REL="PREVIOUS"
TITLE="createuser"
HREF="app-createuser.html"><LINK
REL="NEXT"
TITLE="destroyuser"
HREF="app-destroyuser.html"></HEAD
><BODY
BGCOLOR="#FFFFFF"
TEXT="#000000"
><DIV
CLASS="NAVHEADER"
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>PostgreSQL User's Guide</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="app-createuser.html"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="app-destroyuser.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><SPAN
CLASS="APPLICATION"
>destroydb</SPAN
></H1
><DIV
CLASS="REFNAMEDIV"
><H2
>Name</H2
><SPAN
CLASS="APPLICATION"
>destroydb</SPAN
> &#8212; Create a new <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
> database</DIV
><DIV
CLASS="REFSYNOPSISDIV"
><PRE
CLASS="SYNOPSIS"
>destroydb [ <TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
> ]
destroydb [ -h <TT
CLASS="REPLACEABLE"
><I
>host</I
></TT
> ] [ -p <TT
CLASS="REPLACEABLE"
><I
>port</I
></TT
> ]
    [ -i ] [ <TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
> ]</PRE
><DIV
CLASS="REFSECT2"
><H3
>Inputs</H3
><P
>&#13;<P
></P
></P><DL
><DT
>-h <TT
CLASS="REPLACEABLE"
><I
>host</I
></TT
></DT
><DD
><P
>Specifies the hostname of the machine on which the 
<SPAN
CLASS="APPLICATION"
>postmaster</SPAN
>
is running.  Defaults to using a local Unix domain socket
 rather than an IP connection..&#13;</P
></DD
><DT
>-p <TT
CLASS="REPLACEABLE"
><I
>port</I
></TT
></DT
><DD
><P
>Specifies the Internet TCP/IP port or local Unix domain socket file 
extension on which the <SPAN
CLASS="APPLICATION"
>postmaster</SPAN
>
is listening for connections.  The port number defaults to 5432,
 or the value of the <TT
CLASS="ENVAR"
>PGPORT</TT
>
environment variable (if set).&#13;</P
></DD
><DT
>-i</DT
><DD
><P
>Run in interactive mode.
Prompts for confirmation before destroying a database.&#13;</P
></DD
><DT
><TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
></DT
><DD
><P
>Specifies the name of the database to be destroyed.  The database
must be one of the existing <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
> databases
 in this installation.
<TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
>
defaults to the value of the
<TT
CLASS="ENVAR"
>USER</TT
>
environment variable.&#13;</P
></DD
></DL
><P>&#13;</P
></DIV
><DIV
CLASS="REFSECT2"
><H3
>Outputs</H3
><P
><SPAN
CLASS="APPLICATION"
>destroydb</SPAN
> will remove files from the
<TT
CLASS="FILENAME"
><TT
CLASS="ENVAR"
>PGDATA</TT
>/<TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
>/</TT
>
data area for the existing database.

<P
></P
></P><DL
><DT
>Connection to database 'template1' failed.
connectDB() failed: Is the postmaster running and accepting connections
 at 'UNIX Socket' on port '<TT
CLASS="REPLACEABLE"
><I
>port</I
></TT
>'?
destroydb: database destroy failed on <TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
>.</DT
><DD
><P
><SPAN
CLASS="APPLICATION"
>destroydb</SPAN
> could not attach to the 
<SPAN
CLASS="APPLICATION"
>postmaster</SPAN
> 
process on the specified host and port.  If you see this message,
ensure that the <SPAN
CLASS="APPLICATION"
>postmaster</SPAN
> 
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.&#13;</P
></DD
><DT
>Connection to database 'template1' failed.
FATAL 1:  SetUserId: user '<TT
CLASS="REPLACEABLE"
><I
>username</I
></TT
>' is not in 'pg_shadow'
destroydb: database destroy failed on <TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
>.</DT
><DD
><P
>You do not have a valid entry in the relation <TT
CLASS="LITERAL"
>pg_shadow</TT
>
and and will not be allowed to access <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
>. 
Contact your <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
> administrator.&#13;</P
></DD
><DT
>ERROR:  user '<TT
CLASS="REPLACEABLE"
><I
>username</I
></TT
>' is not allowed to create/destroy databases
destroydb: database destroy failed on <TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
>.</DT
><DD
><P
>You do not have permission to destroy (or create) databases. 
Contact your <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
> site administrator.&#13;</P
></DD
><DT
>ERROR:  destroydb: database '<TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
>' does not exist.
destroydb: database destroy failed on <TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
>.</DT
><DD
><P
>The database to be removed does not have an entry in the
<TT
CLASS="LITERAL"
>pg_database</TT
> class.&#13;</P
></DD
><DT
>ERROR:  destroydb: database '<TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
>' is not owned by you.
destroydb: database destroy failed on <TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
>.</DT
><DD
><P
>You are not the Database Administrator (DBA) for the specified database.&#13;</P
></DD
><DT
>destroydb: database destroy failed on <TT
CLASS="REPLACEABLE"
><I
>dbname</I
></TT
>.</DT
><DD
><P
>An internal error occurred in <SPAN
CLASS="APPLICATION"
>psql</SPAN
>
or in the backend server.  Ensure that your site administrator has
properly installed <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
>and initialized the site with 
<SPAN
CLASS="APPLICATION"
>initdb</SPAN
>.&#13;</P
></DD
></DL
><P>

<BLOCKQUOTE
CLASS="NOTE"
><P
><B
>Note: </B
><SPAN
CLASS="APPLICATION"
>destroydb</SPAN
> internally runs
<B
CLASS="COMMAND"
>DESTROY DATABASE</B
> from <SPAN
CLASS="APPLICATION"
>psql</SPAN
>
while connected to the <TT
CLASS="LITERAL"
>template1</TT
> database.</P
></BLOCKQUOTE
>&#13;</P
></DIV
></DIV
><DIV
CLASS="REFSECT1"
><H2
>Description</H2
><P
><SPAN
CLASS="APPLICATION"
>destroydb</SPAN
> destroys an existing
<SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
> database.
The person who executes this command must be
the database administrator, or <SPAN
CLASS="ACRONYM"
>DBA</SPAN
>,
or must be the <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
> super-user.
The program runs silently; no confirmation message will be displayed.
After the database is destroyed, a Unix shell prompt will reappear.&#13;</P
><P
>All references to
the database are removed, including the directory containing this
database and its associated files.&#13;</P
><P
><SPAN
CLASS="APPLICATION"
>destroydb</SPAN
> is a shell script that invokes
<SPAN
CLASS="APPLICATION"
>psql</SPAN
>.
Hence, a <SPAN
CLASS="APPLICATION"
>postmaster</SPAN
>
process must be running on the database server host before
<SPAN
CLASS="APPLICATION"
>destroydb</SPAN
>
is executed. The 
<TT
CLASS="ENVAR"
>PGOPTION</TT
>
and
<TT
CLASS="ENVAR"
>PGREALM</TT
>
environment variables will be passed on to
<SPAN
CLASS="APPLICATION"
>psql</SPAN
>
and processed as described in <A
HREF="app-psql.html"
><I
><I
>psql</I
></I
></A
>.&#13;</P
></DIV
><DIV
CLASS="REFSECT1"
><H2
>Usage</H2
><P
>To destroy the database <TT
CLASS="LITERAL"
>demo</TT
>
 using the postmaster on the local host, port 5432:
<PRE
CLASS="PROGRAMLISTING"
>destroydb demo</PRE
>&#13;</P
><P
>To destroy the database <TT
CLASS="LITERAL"
>demo</TT
>
 using the postmaster on host eden, port 5000:
<PRE
CLASS="PROGRAMLISTING"
>destroydb -p 5000 -h eden demo</PRE
>&#13;</P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="app-createuser.html"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="user.html"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="app-destroyuser.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><SPAN
CLASS="APPLICATION"
>createuser</SPAN
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="utilities.html"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><SPAN
CLASS="APPLICATION"
>destroyuser</SPAN
></TD
></TR
></TABLE
></DIV
></BODY
></HTML
>