Skip to main content

PITR Cluster is stuck at 87% with status is Setting up primary

Shanshan Zhao
  • Updated

Background

Perform a cluster restore with Point in Time Restore (also called, PITR).

The newly restored cluster is stuck at 87% and its status is Setting up primary.

Cause

The selected time in PITR is after the last transaction commit time. We also can say the cluster has been idle since the selected time. So a fully restored cluster will be the same as PITR at the selected time.

Solution

  1. Go to EDB Postgres AI console
  2. Delete the cluster that was stuck
  3. Restore a cluster with the Fully Restore option

If there is any question or concern, please get in touch with EDB Docs - EDB Postgres AI Cloud support options (enterprisedb.com)