Upgrade patroni cluster in DR to 1.5.5
Currently DR cluster is running as a wal only standby cluster. However, because of a bug in patroni, the standby cluster's recovery.conf has None
as host and port number
primary_conninfo = 'user=gitlab-replicator password=phahChu2xahngeimahFiec4ahng0ou3cu3gahN0raakie0xae5aevamaMiet9iph host=None port=None sslmode=prefer sslcompression=1 application_name=patroni-01-db-dr.c.gitlab-dr.internal'
This caused lots of errors in postgres error log 2019-02-22_16:26:06 patroni-01-db-dr postgres[7393]: [3-1] 2019-02-22 16:26:06 GMT [7393]: [1-1] FATAL: could not connect to the primary server: invalid port number: "None"
This bug is fixed in patroni version 1.5.5 https://github.com/zalando/patroni/blob/c6e70a9910ac69381ebb00d056b0c44aa67751bb/docs/releases.rst#id5
Don't write primary_conninfo into recovery.conf for wal-only standby cluster (Alexander)
Despite not having neither host nor port defined in the standby_cluster config, Patroni was putting the primary_conninfo into the recovery.conf, which is useless and generating a lot of errors.
We should upgrade the version in DR cluster to 1.5.5