Re: [GENERAL] Is it OK to create a directory in PGDATA dir

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: [GENERAL] Is it OK to create a directory in PGDATA dir
Дата
Msg-id 21bb9629-aef9-1d2d-f6d6-45cb7e73c24c@hogranch.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Is it OK to create a directory in PGDATA dir  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: [GENERAL] Is it OK to create a directory in PGDATA dir
Список pgsql-general
On 10/19/2017 1:25 PM, Tomas Vondra wrote:
Is it fine to create a subdir inside PGDATA and store our stuff
there, or will PG freak out seeing a foreign object.

PostgreSQL certainly does not check if there are unknown directories in
the data directory, and it will not crash and burn. But it causes all
sorts of problems, and it increases the probability of human error.


most importantly, ONLY the postgres system process should have access to the pgdata directory, it should have permissions 700.   your apps should be running as a different user, and that user won't have access to said PGDATA.


-- 
john r pierce, recycling bits in santa cruz

В списке pgsql-general по дате отправления:

Предыдущее
От: rakeshkumar464
Дата:
Сообщение: Re: [GENERAL] Is it OK to create a directory in PGDATA dir
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [GENERAL] Is it OK to create a directory in PGDATA dir