External postgresql for Gitlab

Keywords: GitLab - Virtual Machines - How to - Upgrade

Description:
With external postgresql to Gitlab should we need to install postgresql on Gitlab server ?

Also I noticed 2 postgresql versions 12 and 13 in gitlab@14.1.7 server under the location /opt/gitlab/embedded/postgresql/. so when we are upgrading which version of psql or pg_dump will be communicating with external postgresql and how to know which version of postgresql version is running on the server side

Hi @ctr0306

Thanks for using Bitnami Gitlab CE!

With external postgresql to Gitlab should we need to install postgresql on Gitlab server ?

The VirtualMachine image for Bitnami Gitlab CE comes with a PostgreSQL server by default, which is the one used by the application. Nevertheless, you can opt to use an external PostgreSQL server if you wish. In order to do that, you can refer to their official documentation:

https://docs.gitlab.com/ee/administration/postgresql/external.html

so when we are upgrading which version of psql or pg_dump will be communicating with external postgresql and how to know which version of postgresql version is running on the server side

The latest Bitnami Gitlab CR release (14.3.3-ce.0-0) uses PostgreSQL 12, so yours most likely will be using the same. In order to verify it, you can simply connect to the database and the version will be prompted:

sudo gitlab-psql -d gitlabhq_production
psql (12.7)
Type "help" for help.
gitlabhq_production=# 

Best regards,
Jose Antonio Carmona


Was my answer helpful? Click on :heart: