Manage PostgreSQL Database for GITLAB Application? - Mailing list pgsql-general

From Hilbert, Karin
Subject Manage PostgreSQL Database for GITLAB Application?
Date
Msg-id DM6PR02MB4876CBD53ECBC0D2A12A6DF9899F0@DM6PR02MB4876.namprd02.prod.outlook.com
Whole thread Raw
Responses Re: Manage PostgreSQL Database for GITLAB Application?
Re: Manage PostgreSQL Database for GITLAB Application?
List 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@psu.edu
IM - ioh1@chat.psu.edu

pgsql-general by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: commit within a procedure loop - cannot commite with subtransaction
Next
From: andyterry
Date:
Subject: Re: commit within a procedure loop - cannot commite withsubtransaction