Configuring PostgreSQL for scaling
In this section, you are guided through configuring a PostgreSQL database to be used with GitLab in one of our reference architectures.
Configuration options
Choose one of the following PostgreSQL configuration options:
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
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.