How to Downgrade PostgreSQL from 11 to 9 to Fix "pg_dump: Aborting Because of Server Version Mismatch" Error
In the world of GitLab and PostgreSQL, compatibility is crucial. When using GitLab Omnibus, you’ll find it ships with PostgreSQL 9.6. However, if you’re leveraging an external PostgreSQL database container, it’s essential to adhere to a key requirement: GitLab only supports the exact version of PostgreSQL internally and externally. This subtlety often gets lost in the shuffle, especially for those new to the ecosystem. To put it plainly, if you’re running a Docker installation of GitLab, you must use PostgreSQL 9.6—no more, no less. ...