How can I connect to postgresql gitlab

 On 7.14.1:

cat /var/opt/gitlab/gitlab-rails/VERSION
7.14.1

I do this:

sudo -u gitlab-psql -i bash
/opt/gitlab/embedded/bin/psql --port 5432 -h /var/opt/gitlab/postgresql -d gitlabhq_production
psql (9.2.10)
Type "help" for help.

gitlabhq_production=# 

to connect to gitlabqh_production database.

For me, this also works:

sudo -u gitlab-psql /opt/gitlab/embedded/bin/psql -h /var/opt/gitlab/postgresql -d gitlabhq_production
psql (9.2.10)
Type "help" for help.

gitlabhq_production=# 

sudo -u gitlab-psql /opt/gitlab/embedded/bin/psql -h /var/opt/gitlab/postgresql -d gitlabhq_production 
works for me.

Read More