Top
Enterprise Postgres 14 SP1 Operation Guide
FUJITSU Software

16.3.1 Using WebAdmin

You can use WebAdmin to recover data to a backup point.

Note

Recovery operation cannot be performed on an instance that is part of a streaming replication cluster in standby mode.

If disk failure occurs on a standby instance, it may be necessary to delete and re-create the instance.

Recovery operation can be performed on an instance that is part of a streaming replication cluster in "Master" mode. If a recovery operation is performed on a master instance, it will break the replication cluster and streaming replication will stop between the master instance and all its standby instances. In such an event, the standby instances can be promoted to standalone instances or can be deleted and re-created.

Follow the procedure below to recover the data in the data storage disk.

  1. Stop applications

    Stop applications that are using the database.

  2. Stop the instance

    Stop the instance. Refer to "2.1.1 Using WebAdmin" for information on how to stop an instance.

  3. Recover the keystore, and enable automatic opening of the keystore

    Do the following if the data in the database has been encrypted:

    • Restore the keystore to its state at the time of the database backup.

    • Enable automatic opening of the keystore.

  4. Recover the database cluster

    Log in to WebAdmin, and in the [Instances] tab, select the instance to be recovered and click .

  5. Recover to the backup point

    In the [Restore Instance] dialog box, click [Yes].

    Recovery is performed. An instance is automatically started when recovery is successful.

  6. Resume database operations

    If necessary, re-execute transaction processing from the backup point to when an erroneous operation was performed, and then resume database operations.