Chapter 20. Managing Databases

Table of Contents
20.1. Overview
20.2. Creating a Database
20.3. Template Databases
20.4. Database Configuration
20.5. Destroying a Database
20.6. Tablespaces

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.

Every instance of a running PostgreSQL server manages one or more databases. Databases are therefore the topmost hierarchical level for organizing SQL objects ("database objects"). This chapter describes the properties of databases, and how to create, manage, and destroy them.