Product Documentation

Appearance

ALTER DATABASE DROP REPLICA ​

Drop a replica object from a source system.

ALTER DATABASE local_database_name DROP REPLICA replica_name

When you drop a replica, its corresponding backup chain on the source system is also dropped. Note that dropping a replica on the source system does not drop the backup chain on the target system.

For example:

premdb=# alter database premdb drop replica premdb_replica;
DROP REPLICA

In this example, the replica cannot be dropped because replication is in progress:

premdb=# alter database premdb drop replica premdb_replica;
ERROR:  Failed to drop replica
DETAIL:  Cannot drop replica premdb_replica from database premdb because it is currently running

In order to drop this replica, you have to pause replication first:

premdb=# alter database premdb alter replica premdb_replica pause;
PAUSE REPLICA
premdb=# alter database premdb drop replica premdb_replica;
DROP REPLICA

Parent topic:SQL Commands