These are the current limitations of WarehousePG Disaster Recovery. Where applicable, workarounds are included to help mitigate the impact.
Concurrent restore-point creation from multiple hosts isn't supported. Running
whpg-dr create-restore-pointconcurrently from different machines against the same cluster produces unreliable restore-point records in the backup repository. Run restore-point creation from one designated host at a time.The DR cluster must not be initialized before restore. Running
gpinitsystemon the DR cluster beforewhpg-dr restorecauses the restore to fail. Follow the WarehousePG install guide through Creating the Data Storage Areas, then stop. Don't proceed to Initializing WarehousePG. Ifgpinitsystemhas already been run, delete the data directories on all DR hosts before attempting a restore.No pre-restore WAL completeness check.
whpg-dr restoredoesn't verify that all WAL files required to reach the target restore point are present in storage before starting. If a WAL file is missing, the restore fails part-way through:WARNING: WAL replay did not complete. Data directories for 1 coordinator and N segments were modified, but the restore-last state file has NOT been updated.
The failing segment's
startup.logshows apg_ctl startfailure but doesn't identify which WAL file is absent. Runwhpg-dr checkand verify the storage repository before restoring. If the restore fails, re-run it with--resume-failedafter investigating log output in$HOME/gpAdminLogs.No failback automation. After promoting the DR cluster to a writable primary, reversing roles isn't automated. To use the original primary as a DR site, re-initialize it as a new DR cluster and run a fresh base backup.