Manage PostgreSQL Database for GITLAB Application?

Поиск
Список
Период
Сортировка
От Hilbert, Karin
Тема Manage PostgreSQL Database for GITLAB Application?
Дата
Msg-id DM6PR02MB4876CBD53ECBC0D2A12A6DF9899F0@DM6PR02MB4876.namprd02.prod.outlook.com
обсуждение исходный текст
Ответы Re: Manage PostgreSQL Database for GITLAB Application?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Manage PostgreSQL Database for GITLAB Application?  (Stephen Frost <sfrost@snowman.net>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: commit within a procedure loop - cannot commite with subtransaction
Следующее
От: andyterry
Дата:
Сообщение: Re: commit within a procedure loop - cannot commite withsubtransaction