How to use remote SQL database

PostgreSQL

If you would like to use the remote PostgreSQL database, on the server side you need to allow remote connections from the GitLab host. This can be done using the Ansible inventory variables:

postgresql_server__listen_addresses: [ '*' ]
postgresql_server__allow: [ '192.0.2.0/24' ]

On the GitLab host, you need to enable the debops.postgresql role by adding the host to its respective Ansible inventory group:

[debops_service_postgresql]
hostname

The PostgreSQL client role also needs to be pointed to the remote database server, it can be done using the Ansible inventory variables:

postgresql__server: 'sqldb.example.org'

The debops.gitlab role should detect the PostgreSQL configuration automatically. If not, you can force the use of the PostgreSQL server through the Ansible inventory:

gitlab__database: 'postgresql'

MariaDB/MySQL

MariaDB / MySQL databases are not supported anymore. GitLab's developers themselves discourage their use: https://docs.gitlab.com/ce/install/requirements.html#database.