GPDR Configure Backup Fails with ERROR: archive_mode must be enabled

Products

• VMware Tanzu Data Suite
• VMware Tanzu Data Suite
• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire

Issue/Introduction

During GPDR configuration, the gpdr configure backup command may fail with an error stating that archive_mode must be enabled. This error can occur even when archive_mode appears to be enabled at the cluster level.

ERROR: archive_mode must be enabled

Environment

GPDB - 6.X

GPDR - 1.2.X

Cause

Although gpdr configure backup automatically enables archive_mode, the validation step may fail due to one or more of the following conditions:

• A previous failed or interrupted gpdr configure backup run left stale GPDR state or partial configuration files

• archive_mode was manually modified outside of GPDR (for eg:, by editing postgresql.conf)

• The Greenplum cluster was not restarted after GPDR attempted to enable WAL archiving

• One or more primary segments did not successfully receive or apply the updated configuration

 

Resolution

1. Remove Stale GPDR Configuration (If Present)

If gpdr configure backup was previously interrupted or failed, remove partial configuration files before retrying:

rm -f /usr/local/gpdr/configs/pgbackrest-*.conf
rm -rf /usr/local/gpdr/state/*

 

2. Restart GPDB cluster : 

gpstop -r

3. Re-run the configuration command

gpdr configure backup --config-file <config_file.yml>

4. Verify archive_mode 

SHOW archive_mode;