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 reference architectures. There are essentially three setups to choose from.
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, Patroni, and repmgr are bundled in the package, so you can it to set up the whole PostgreSQL infrastructure (primary, replica).
Standalone PostgreSQL using Omnibus GitLab (FREE SELF)
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.