Pivotal Knowledge Base

Follow

gpinitstandby failed with "pg_basebackup: could not connect to server: FATAL: option not supported: "replication"

Environment

Pivotal Greenplum(GPDB) v4.3.0.0

Problem

During the standby initialization , you encounter the below error message.

gpinitstandby:mdw:gpadmin-[ERROR]:-Error initializing standby master: ExecutionError: 'non-zero rc: 1' occured. Details: 'ssh -o 'StrictHostKeyChecking no' smdw ". /usr/local/greenplum-db/./greenplum_path.sh; pg_basebackup -x -R -E ./pg_log -E ./gp_dumps -E ./gpperfmon/data -D /data/master/gpseg-1 -h mdw -p 5432"' cmd had rc=1 completed=True halted=False
stdout=''
stderr='pg_basebackup: could not connect to server: FATAL: option not supported: "replication"

Cause

During the GPDB upgrade from v4.2.x to v4.3.0.0 if the upgrade failed or had errors during execution then starting the GPDB using v4.3 binary file and running gpinitstandby would lead to this error message.

Resolution

Run gpmigrator/gpmigrator_mirror again and make sure it finished without any error.

Comments

Powered by Zendesk