Configuring PostgreSQL for scaling

In this section, you’ll be guided through configuring a PostgreSQL database to be used with GitLab in one of our Scalable and Highly Available Setups. There are essentially three setups to choose from.

PostgreSQL replication and failover with Omnibus GitLab

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, Patroni, and repmgr are bundled in the package, so you can it to set up the whole PostgreSQL infrastructure (primary, replica).

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

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