Re: Could not create a tablespace - permission denied

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Could not create a tablespace - permission denied
Дата
Msg-id 13554.1208639462@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Could not create a tablespace - permission denied  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-admin
"Joshua D. Drake" <jd@commandprompt.com> writes:
> Graham Leggett wrote:
>> - edit /etc/group and add postgres to the group user

> Aha! there it is. Adding a user to a group doesn't mean anything until
> that user reinitializes the environment.

In particular, it looks like the list of groups you belong to is
typically only computed at login time (or equivalently su -l, which
is what's happening in the postgres init script), and then just
inherited by all processes launched from that login.  So there is
caching of a sort going on here, but it's in the kernel and there's
nothing we can do about it.

            regards, tom lane

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Could not create a tablespace - permission denied
Следующее
От: "Phillip Smith"
Дата:
Сообщение: Re: Database update problem from crontab on ubuntu server