Re: Could not create a tablespace - permission denied - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: Could not create a tablespace - permission denied
Date
Msg-id 480A3F49.7080406@commandprompt.com
Whole thread Raw
In response to Re: Could not create a tablespace - permission denied  (Graham Leggett <minfrin@sharp.fm>)
Responses Re: Could not create a tablespace - permission denied
List pgsql-admin
Graham Leggett wrote:
> Joshua D. Drake wrote:
>
>> I am pretty sure you are missing something. I can not reproduce your
>> issue:
>
> Do it like this:
>
> - mkdir /tmp/foo
> - chown user:user /tmp/foo
> - 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. That is why restarting
postgresql resolves the issue. When postgresql is started, is actually
launches a new shell as the user and the fact that they are part of the
group is picked up.


Sincerely,

Joshua D. Drake




pgsql-admin by date:

Previous
From: Graham Leggett
Date:
Subject: Re: Could not create a tablespace - permission denied
Next
From: Tom Lane
Date:
Subject: Re: Could not create a tablespace - permission denied