Chapter 21. Managing Databases

Table of Contents

21.1. Postgres Pro Shardman Overview
21.2. Connecting and Working with a Postgres Pro Shardman Cluster
21.3. Creating a Database
21.4. Template Databases
21.5. Database Configuration
21.6. Destroying a Database
21.7. Tablespaces

Every instance of a running Postgres Pro Shardman 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.

The managing principles described in this chapter are applied for regular and distributed systems, yet only for local sharded DBs as, for now, sharding works only for a database named postgres (default), creating other databases is in development.