Re: Manage PostgreSQL Database for GITLAB Application?

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@psu.edu
> IM - ioh1@chat.psu.edu
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com