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(at)psu(dot)edu
> IM - ioh1(at)chat(dot)psu(dot)edu
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com