Setup phpPgAdmin with Gitlab PostgreSQL server

Hi,

I like to setup phpPgAdmin for PostgreSQL database (simular to phpmyadmin for mysql) for Gitlab-CE omnibus version.

I already successfully setup phpPgAdmin itself. Next, I added a new database user via:

su - gitlab-psql  

Then joining the db:

/opt/gitlab/embedded/bin/psql gitlabhq_production

Add new user & rights:

CREATE USER blah WITH PASSWORD 'blah '; 
GRANT ALL PRIVILEGES ON DATABASE gitlabhq_production to blah; 
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO blah;

I changed the phpPgAdmin settings:

nano /usr/share/phpPgAdmin/conf/config.inc.php

To:

$conf['extra_login_security'] =false;

Now I’m trying to login with this new user in phpPgAdmin, however it still fails with “login failed”. How to continue? I think phpPgAdmin doesn’t have access to the PostgreSQL database. It seems the omnibus PostgreSQL process is kinda sandboxed…?

I don’t know which settings I need to change in order to view the gitlab database in phpPgAdmin.

Thanks in advance!

Kind regards,
Melroy van den Berg

I think I need to change some gitlab.rb settings in order to let this work??

HI @danger89 did you find a solution to this?