Skip to content
GitLab
Next
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • omnibus-gitlab omnibus-gitlab
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
    • Locked Files
  • Issues 1,061
    • Issues 1,061
    • List
    • Boards
    • Service Desk
    • Milestones
    • Iterations
    • Requirements
  • Merge requests 67
    • Merge requests 67
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • Code review
    • Insights
    • Issue
    • Repository
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • GitLab.orgGitLab.org
  • omnibus-gitlabomnibus-gitlab
  • Issues
  • #5575
Closed
Open
Issue created Aug 11, 2020 by Nick Nguyen@nhxnguyenDeveloper0 of 2 checklist items completed0/2 checklist items

Update replicate-geo-database to support PostgreSQL 12

Context

Follow-up from verification testing of PG12 with Geo installs:

After some manual adjustments, I verified replication is working for the various data types we've listed in the description. At the moment, deploying Geo with PostgreSQL 12 is not recommended.

This is what I think is needed to support PG12 with a fresh Geo install:

  • Pre 14.0 release (13.3 if possible, but might have to be 13.4 at this point)
    • Modify gitlab-ctl replicate-geo-database to detect if PG12 is enabled. If enabled, instead of creating recovery.conf, the script writes the settings to postgresql.conf (except standby_mode), and creates files for recovery.signal and standby.signal.

Proposal

  • Modify gitlab-ctl replicate-geo-database to detect if PG12 is enabled.
    • If enabled, instead of creating recovery.conf, the script writes the settings to postgresql.conf (except standby_mode), and creates standby.signal file.
  • Re-verify Geo installation with PostgreSQL 12
Edited Aug 11, 2020 by Nick Nguyen
Assignee
Assign to
Time tracking