| Postgres-XC 1.2 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 20. Managing Databases | Fast Forward | Next |
Note: XCONLY: The following description applies only to Postgres-XC.
Please note that this section describes the task of individual Coordinator and Datanode. It should be done for each of them.
Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly. You can read PostgreSQL as Postgres-XC except for version number, which is specific to each product.
Databases are destroyed with the command DROP DATABASE:
DROP DATABASE name;
Only the owner of the database, or a superuser, can drop a database. Dropping a database removes all objects that were contained within the database. The destruction of a database cannot be undone.
You cannot execute the DROP DATABASE command while connected to the victim database. You can, however, be connected to any other database, including the template1 database. template1 would be the only option for dropping the last user database of a given cluster.
For convenience, there is also a shell program to drop databases, dropdb:
dropdb dbname
(Unlike createdb, it is not the default action to drop the database with the current user name.)