Skip to content
Snippets Groups Projects

Postgresql replication

    • Closed Issue created by brancott @brancott

    Hi guys, I'm trying to set up a postgresql replication and fail to do so

    root@git2:/var/opt/gitlab/postgresql/data# sudo -u gitlab-psql /opt/gitlab/embedded/bin/psql -h /var/opt/gitlab/postgresql/ gitlabhq_production psql (11.7) Type "help" for help.

    gitlabhq_production=# CREATE SUBSCRIPTION gitlab CONNECTION 'host=10.20.9.61 dbname=gitlabhq_production user=gitlab_replicator password=Diasoft1 port=5432' PUBLICATION gitlab; ERROR: could not connect to the publisher: could not connect to server: Connection refused Is the server running on host "10.20.9.61" and accepting TCP/IP connections on port 5432?

    gitlab.rb on main server:

    postgresql['listen_address'] = nil

    postgresql['port'] = 5432

    postgresql['wal_level'] = "logical" postgresql['max_wal_senders'] = 5 postgresql['max_replication_slots'] = 2 postgresql['sql_replication_user'] = "gitlab_replicator" postgresql['sql_replication_password'] = "xxxxxxxxxxxxxxxxx" postgresql['custom_pg_hba_entries'] = { REPLICATION: [ # APPLICATION should identify what the settings are used for { type: "host", database: "gitlabhq_production", user: "gitlab_replicator", cidr: "10.20.9.146/32", method: "md5", #option: example } ] }

    So how to make replication work?

    Is replication not supported for community version at all?

    Edited by brancott

    Designs

      Child items ...

      2. Activity

      Please register or sign in to reply