Skip to content

Failed to reconfigure when `postgresql['listen_address']` is set to not null

Summary

I've encountered the exact same issue as in: #4566 (closed) following the steps to setup geo replication according to: https://gitlab.com/gitlab-org/gitlab/-/blob/v12.9.2-ee/doc/administration/geo/replication/database.md

The documentation misses the mandatory setting:

postgresql['trust_auth_cidr_addresses'] = ['127.0.0.1/24']

It took me a while to find the above issue number with the fix. It would be more than helpful if this is added to the documentation.

Steps to reproduce

Follow the steps on https://gitlab.com/gitlab-org/gitlab/-/blob/v12.9.2-ee/doc/administration/geo/replication/database.md to setup geo replication. Primary node fails to start correctly after the Step 7 in the documentation.

What is the current bug behavior?

See issue #4566 (closed)

What is the expected correct behavior?

Gitlab primary node starts without errors.

Relevant logs

See #4566 (closed)

Details of package version

I am running the omnibus dockerhub: gitlab/gitlab-ee:12.9.2-ee.0 image.

Environment details

  • Operating System: Ubuntu 18.04 LTS
  • Docker: version 19.03.8
  • Installation Target, remove incorrect values:
    • VM: VirtualBox (test environment)
  • Installation Type, remove incorrect values:
    • New Installation
  • Is there any other software running on the machine: yes, firm (firewall), docker
  • Is this a multiple node installation: test to setup geo replication?
  • Resources
    • CPU: 2
    • Memory total: 3GB

Configuration details

Provide the relevant sections of `/etc/gitlab/gitlab.rb` 
postgresql['listen_address'] = '0.0.0.0'
postgresql['port'] = '5432'
postgresql['sql_user_password'] = '4146f87cb3f0e657dbffecfb8c2f2e50'
postgresql['md5_auth_cidr_addresses'] = ['192.168.56.3/32','192.168.56.8/32']