Databases

As discussed in the Requirements section, PostgreSQL is the database that's recommended by GitLab for running with full feature availability. You can find out how to download it from the PostgreSQL website at https://www.postgresql.org/download/.

Once installed, connect to the database via a psql session with an admin user and run the following commands:

CREATE USER git CREATEDB;CREATE EXTENSION IF NOT EXISTS pg_trgm; -- Enables an extension required by GitLabCREATE DATABASE gitlabhq_production OWNER git;

Now, you should have your database set up. First, we'll need to log in and set a password for this user:

sudo -u git -H psql gitlabhq_production\password

Exit the database connection with \q and move on to the other main datastore, ...

Get GitLab Quick Start Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.