PostgreSQL FDW support for Geo
This implements support for FDW based on https://gitlab.com/gitlab-org/gitlab-ee/issues/3382. This was built as a continuation of !1984 (merged)
-
Enable FDW Extension -
Create FDW Server -
Update FDW Server -
Only update FDW Server when host
,port
oudbname
changed -
Create user mapping for FDW Server -
Update user mapping for FDW Server -
Grant usage for mapped user on FDW Server -
Only execute Grant when it doesn't exist -
Only update user mapping when user
orpassword
changed -
Refresh foreign table definition at each revision (depends on gitlab-org/gitlab-ee!3627)
Closes #2760 (closed) Related gitlab-org/gitlab-ee#3382
Caveats:
In order for the FDW to connect to the server, it has to connect with a user with password associated.
That means we need to define a password for gitlab-rails in primary (and secondary), as we are reading it from node['gitlab']['gitlab-rails']['db_password']
Edited by GitLab Release Tools Bot