You need to sign in or sign up before continuing.
pg-upgrade does not support with seperate machine for Geo tracking database
When gitlab-ctl pg-upgrade
is ran on a Geo secondary it detects it needs to do special stuff (see geo_secondary_upgrade
), which is great.
But I does not support running postgresql
and geo-postgresql
running on separate machines:
$ gitlab-ctl pg-upgrade
Checking for an omnibus managed postgresql: NOT OK
No currently installed postgresql in the omnibus instance found.
To be able to update the tracking db (only tracking db), I had to temporary add postgresql['enable'] = true
to gitlab.rb
.
Secondary PostgreSQL node gitlab.rb
external_url 'http://secondary-ha-postgresql.gogitlab.ml' roles ['postgres_role'] repmgr['enable'] = false consul['enable'] = false prometheus['enable'] = false alertmanager['enable'] = false pgbouncer_exporter['enable'] = false redis_exporter['enable'] = false gitlab_monitor['enable'] = false postgresql['listen_address'] = '10.164.0.30' postgresql['md5_auth_cidr_addresses'] = ['10.164.0.30/32', '10.164.0.31/32', '10.164.0.34/32', '10.164.0.35/32'] postgresql['hot_standby'] = 'on' postgresql['sql_user_password'] = '' gitlab_rails['db_password'] = '' geo_postgresql['enable'] = false gitlab_rails['auto_migrate'] = false geo_secondary['auto_migrate'] = false roles ['geo_secondary_role']
Secondary tracking database node gitlab.rb
external_url 'http://secondary-ha-tracking.gogitlab.ml' geo_postgresql['enable'] = true geo_postgresql['listen_address'] = '10.164.0.31' geo_postgresql['sql_user_password'] = '' geo_secondary['db_fdw'] = true geo_postgresql['fdw_external_password'] = '' geo_postgresql['md5_auth_cidr_addresses'] = ['10.164.0.30/32'] geo_postgresql['trust_auth_cidr_addresses'] = %w(10.164.0.34/32 10.164.0.35/32) gitlab_rails['db_host'] = '10.164.0.30' gitlab_rails['auto_migrate'] = false alertmanager['enable'] = false consul['enable'] = false gitaly['enable'] = false gitlab_monitor['enable'] = false gitlab_workhorse['enable'] = false nginx['enable'] = false node_exporter['enable'] = false pgbouncer_exporter['enable'] = false postgresql['enable'] = true prometheus['enable'] = false redis['enable'] = false redis_exporter['enable'] = false repmgr['enable'] = false sidekiq['enable'] = false unicorn['enable'] = false geo_secondary['auto_migrate'] = false roles ['geo_secondary_role']
Edited by Fabian Zimmer