From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Graham Leggett <minfrin@sharp.fm>
Cc: pgsql-admin@postgresql.org
Subject: Re: Could not create a tablespace - permission denied
Date: Sat, 19 Apr 2008 17:11:02 -0400
Message-ID: <13554.1208639462@sss.pgh.pa.us> (raw)
In-Reply-To: <480A3F49.7080406@commandprompt.com>
References: <4809EC7B.6060902@sharp.fm>
<9189.1208619241@sss.pgh.pa.us>
<480A12F5.5060609@sharp.fm>
<9478.1208620229@sss.pgh.pa.us>
<480A190B.80408@sharp.fm>
<480A1A55.6090800@commandprompt.com>
<480A381D.3030908@sharp.fm>
<480A3F49.7080406@commandprompt.com>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, jd@commandprompt.com, minfrin@sharp.fm
Subject: Re: Could not create a tablespace - permission denied
In-Reply-To: <13554.1208639462@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox