From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | "Hilbert, Karin" <ioh1(at)psu(dot)edu>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Manage PostgreSQL Database for GITLAB Application? |
Date: | 2019-01-21 18:33:25 |
Message-ID: | 0c744ddd-9d9c-d4b2-4351-a8efb3ab497f@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2019-01-21 18:53:00 | Re: Manage PostgreSQL Database for GITLAB Application? |
Previous Message | andyterry | 2019-01-21 17:44:44 | Re: commit within a procedure loop - cannot commite with subtransaction |