How to access the Gitlab internal postgreSQL database

I am using the PostgreSQL Database Service shipped with Omnibus GitLab.

My requirement to use the same postgreSQL database shipped with Ominibus and create custom table to store the metadata information in it. This table is used to store notes of sources files that need to use with other application.
Note : We can see notes API, but it is not able to use to store of our own notes of source files.

I connect to existing database with following command.
sudo -u gitlab-psql /opt/gitlab/embedded/bin/psql -h /var/opt/gitlab/postgresql -d gitlabhq_production

Connection is success, I can see list of tables.

But when I am query, I couldn’t find any data. Even I have projects, branches, tags.

  1. What is the reason, not loading any data ?
  2. Is this data visible only to administrator or any GitLab user can connect to this database ?
  3. How database access depends on gilab user roles(developer, maintainer etc)
1 Like

Hi @ruchira.ibm2! Thanks for reaching out about your postgreSQL issue. I tried researching this myself, but came up short.

I would suggest writing in to support@gitlab.com since they are going to want to dig into our account with you and that might expose some data you may not want discussed on a public forum.

Let me know how they help, and once you get sorted, please come back and update us! Thanks!

Just wondering if you could manage query the database?

Yo should introduce ‘;’ at the end of your queries