destroydb [ dbname ] destroydb [ -h host ] [ -p port ] [ -i ] [ dbname ]
Specifies the hostname of the machine on which the postmaster is running. Defaults to using a local Unix domain socket rather than an IP connection.
Specifies the Internet TCP/IP port or local Unix domain socket file extension on which the postmaster is listening for connections. The port number defaults to 5432, or the value of the PGPORT environment variable (if set).
Run in interactive mode. Prompts for confirmation before destroying a database.
Specifies the name of the database to be destroyed. The database must be one of the existing Postgres databases in this installation. dbname defaults to the value of the USER environment variable.
destroydb will remove files from the PGDATA/dbname/ data area for the existing database.
destroydb could not attach to the postmaster process on the specified host and port. If you see this message, ensure that the 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.
You do not have a valid entry in the relation pg_shadow and and will not be allowed to access Postgres. Contact your Postgres administrator.
You do not have permission to destroy (or create) databases. Contact your Postgres site administrator.
The database to be removed does not have an entry in the pg_database class.
You are not the Database Administrator (DBA) for the specified database.
An internal error occurred in psql or in the backend server. Ensure that your site administrator has properly installed Postgresand initialized the site with initdb.
Note: destroydb internally runs DESTROY DATABASE from psql while connected to the template1 database.
destroydb destroys an existing Postgres database. The person who executes this command must be the database administrator, or DBA, or must be the Postgres super-user. The program runs silently; no confirmation message will be displayed. After the database is destroyed, a Unix shell prompt will reappear.
All references to the database are removed, including the directory containing this database and its associated files.
destroydb is a shell script that invokes psql. Hence, a postmaster process must be running on the database server host before destroydb is executed. The PGOPTION and PGREALM environment variables will be passed on to psql and processed as described in psql.
To destroy the database demo using the postmaster on the local host, port 5432:
To destroy the database demo using the postmaster on host eden, port 5000:
destroydb -p 5000 -h eden demo
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.