From: | "Hilbert, Karin" <ioh1(at)psu(dot)edu> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Manage PostgreSQL Database for GITLAB Application? |
Date: | 2019-01-21 17:26:42 |
Message-ID: | DM6PR02MB4876CBD53ECBC0D2A12A6DF9899F0@DM6PR02MB4876.namprd02.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Does anyone manage a PostgreSQL database for a GITLAB application?
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?
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
From | Date | Subject | |
---|---|---|---|
Next Message | andyterry | 2019-01-21 17:41:59 | Re: commit within a procedure loop - cannot commite with subtransaction |
Previous Message | Andrew Gierth | 2019-01-21 16:03:32 | Re: commit within a procedure loop - cannot commite with subtransaction |