On 1/21/19 9:26 AM, Hilbert, Karin wrote:
Does anyone manage a PostgreSQL database for a GITLAB application?
Could you be more specific about the above?:
1) Are talking about installing GitLab as a self-managed server?
2) Or an application that is running over top of GitLab?
I have PostgreSQL v9.6 installed on my server & we are trying to migrate
a GITLAB database there.
The developer says that we need to use the public schema instead of the
schema of the same name as the application user.
The schema that he provided me to restore also is revoking all
privileges from the database owner & instead granting all privileges to
PUBLIC.
Has anyone else run across this? I always thought that granting
privileges to PUBLIC is a bad security thing to do?
Well this really depends on the needs of the application. I would ask
the developer how security is handled?
If anyone can offer any thoughts regarding this, it would be greatly
appreciated.
Thanks, Karin
Karin Hilbert
Database Specialist
Administrative Information Services
Pennsylvania State University
25 Shields Bldg., University Park, PA 16802
Work - 814-863-3633
Email - ioh1@xxxxxxx
IM - ioh1@xxxxxxxxxxxx
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
