Managing Replicated Databases

This topic describes the administrative tasks associated with database replication.

In this Topic:

Dropping a Secondary Database

You can drop a secondary database at any time using the DROP DATABASE command. Only the database owner (i.e. the role with the OWNERSHIP privilege on the database) can drop the database.

Dropping a Primary Database

A primary database cannot be dropped if one or more replicas of the database (i.e. secondary databases) exist. To drop the primary database, first promote a secondary database to serve as the primary database, and then drop the former primary database. Alternatively, drop all of the secondary databases for the primary database, and then drop the primary database.

Note that only the database owner can drop the database.