Geo: Refresh of FDW schemas does not happen in HA environment
From gitlab-com/infrastructure#3389, after getting past #3065 (closed) and #3084 (closed), I see the reconfigure
steps skips the refresh step:
* postgresql_fdw_user_mapping[gitlab_secondary] action create
* postgresql_query[create mapping for gitlab_geo at gitlab_secondary] action run (skipped due to not_if)
* postgresql_query[update mapping for gitlab_geo at gitlab_secondary] action run (skipped due to not_if)
* postgresql_query[grant usage on foreign server gitlab_secondary to gitlab_geo] action run (skipped due to not_if)
(up to date)
* bash[refresh foreign table definition] action run (skipped due to not_if)
* execute[reload geo-postgresql] action nothing (skipped due to action :nothing)
* execute[start geo-postgresql again] action nothing (skipped due to action :nothing)
Are the conditions for refreshing the tables correct here? https://gitlab.com/gitlab-org/omnibus-gitlab/blob/master/files/gitlab-cookbooks/gitlab-ee/recipes/geo-postgresql.rb#L208 pg_helper.is_running?
is false
in an HA environment where the primary is on another node.
/cc: @brodock
Edited by Stan Hu