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