Skip to content

PostgreSQL FDW support for Geo

Gabriel Mazetto requested to merge postgresql_fdw into master

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 ou dbname 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 or password 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

Merge request reports