ALTER ASYNC REPLICATION

The ALTER ASYNC REPLICATION statement modifies the status and parameters of an asynchronous replication instance.

Syntax

ALTER ASYNC REPLICATION <name> SET (option = value [, ...])

name — a name of the asynchronous replication instance.
SET (option = value [, ...]) — asynchronous replication parameters:
- STATE — the state of asynchronous replication. This parameter can only be used in combination with the FAILOVER_MODE parameter (see below). Valid values are:
  - DONE — completion of the asynchronous replication process.
- FAILOVER_MODE — the mode for changing the replication state. This parameter can only be used in combination with the STATE parameter. Valid values are:
  - FORCE — forced failover.

The following statement forces the asynchronous replication process to complete:

ALTER ASYNC REPLICATION my_replication SET (STATE = "DONE", FAILOVER_MODE = "FORCE");