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 a post-restore action that the PostgreSQL instance must take after the instance is restored.

1. Choose a post-restore action.

• 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:

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:

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

For example:

2. Click Restore.