postgresql_cluster icon indicating copy to clipboard operation
postgresql_cluster copied to clipboard

Add restore timeout and Standby Cluster initialization check

Open vitabaks opened this issue 1 year ago • 0 comments

This PR introduces a configurable cluster_restore_timeout variable to replace hardcoded values and provide flexibility. The timeout has been increased to 24 hours, making it more suitable for restoring large databases, including both backup and WAL recovery.

Additionally, we've added the task "Wait for the Standby cluster initialization to complete". This task allows tracking the progress of Standby cluster initialization in the Ansible logs. The same 24-hour timeout is applied to this task to ensure it has ample time to complete for large databases.

Variables:

  • cluster_restore_timeout - backup and WAL restore timeout in seconds, default: 86400 (24 hours)
  • pg_ctl_timeout - pg_ctl start and stop timeout, default: 3600 (1 hour)

Additionally

  • Remove duplicate pgbackrest vars from the inventory.
  • Add task "Check PostgreSQL is started" after start for recovery.

vitabaks avatar Sep 20 '24 10:09 vitabaks