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.
- What is the reason, not loading any data ?
- Is this data visible only to administrator or any GitLab user can connect to this database ?
- How database access depends on gilab user roles(developer, maintainer etc)