Configuring PostgreSQL for scaling (FREE SELF)

In this section, you are guided through configuring a PostgreSQL database to be used with GitLab in one of our reference architectures. There are essentially three setups to choose from.

Standalone PostgreSQL using Omnibus GitLab

This setup is for when you have installed the Omnibus GitLab packages (CE or EE), to use the bundled PostgreSQL having only its service enabled.

> Read how to set up a standalone PostgreSQL instance using Omnibus GitLab

Provide your own PostgreSQL instance

This setup is for when you have installed GitLab using the Omnibus GitLab packages (CE or EE), or installed it from source, but you want to use your own external PostgreSQL server.

> Read how to set up an external PostgreSQL instance

PostgreSQL replication and failover with Omnibus GitLab (PREMIUM SELF)

This setup is for when you have installed GitLab using the Omnibus GitLab Enterprise Edition (EE) package.

All the tools that are needed like PostgreSQL, PgBouncer, and Patroni are bundled in the package, so you can use it to set up the whole PostgreSQL infrastructure (primary, replica).

> Read how to set up PostgreSQL replication and failover using Omnibus GitLab