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:
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:
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!
Melroy van den Berg