Step 6. Specify Post-Restore Action

This step is available only if you have selected the Restore to a specific point in time option at the Specify restore point step of the wizard.

At this step of the wizard, select one of the following post-restore actions that the PostgreSQL instance must take after the instance is restored:

  • Select Promote the PostgreSQL server to accept connections once recovery is finished to make the PostgreSQL instance available for connections.
  • Select Pause recovery process and keep the PostgreSQL server in recovery mode to make the PostgreSQL instance run but not accepting incoming remote TCP connections.

To resume the paused state, use the pg_wal_replay_resume() command:

psql -p <port> -c "SELECT pg_wal_replay_resume();"

where <port> is a port number of the PostgreSQL instance.

  • Select Shut down the PostgreSQL server once recovery process is completed to make the PostgreSQL instance stop upon recovery.

In this case, you will need to start the PostgreSQL instance manually:

  1. Change or remove the recovery.signal configuration file.
  2. Launch the PostgreSQL instance with the pg_ctl command:

$ pg_ctl start -D <data_directory>

where <data_directory> is a data directory of the PostgreSQL instance.

For example:

$ pg_ctl start -D /var/lib/pgsql/13/data

Specifying Post-Restore Action

Page updated 12/1/2023

Page content applies to build