root page 3 of index "pg_class_oid_index" has level 0, expected 1

2019-11-13 Thread Abhijit Gharami
Hi, During major version upgrade from PostgreSQL v9.4 to v9.6 I facing following error: Performing Consistency Checks - Checking cluster versions ok connection to database failed: FATAL: root page 3 of index "pg_class_oid_index" has

PITR based recovery in a primary/standby cluster setup

2019-05-21 Thread Abhijit Gharami
Hi, We have primary and standby PostgreSQL cluster setup and also we have PITR enabled on it. To improve the recovery time we are thinking of recovering the database to both primary and standby at the same time. These are the steps we are following: 1. Restore the base backup to the both primar