Add another tip to Geo replication troubleshooting
It seems people regularly run into the problem where they forget a step in the setup of Geo, so they get the following error:
ERROR: replication slots can only be used if wal_level >= replica
This error seems to happen when on the primary to role was not
configured correctly. The admin should have added
roles ['geo_primary_role']
or geo_primary_role['enable'] = true
to
gitlab.rb
on the primary node.
Since this is a common error, add this as a tip to the troubleshooting section of the error message.
Example output
ERROR: replication slots can only be used if wal_level >= replica
*** Initial replication failed! ***
Replication tool returned with a non zero exit status!
Troubleshooting tips:
- replication should be run by root user
- check if `roles ['geo_primary_role']` or `geo_primary_role['enable'] = true` exists in `gitlab.rb` on the primary node
- check your trust settings `md5_auth_cidr_addresses` in `gitlab.rb` on the primary node
Failed to execute: PGPASSFILE=/var/opt/gitlab/postgresql/.pgpass /opt/gitlab/bin/gitlab-psql -h 10.132.0.24 -p 5432 -U gitlab_replicator -d gitlabhq_production -t -c "SELECT slot_name FROM pg_create_physical_replication_slot('secondary_example');"
### Related issues
https://gitlab.com/gitlab-org/gitlab-ee/issues/9259
Edited by GitLab Release Tools Bot