From: Graham Leggett <minfrin@sharp.fm>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: Could not create a tablespace - permission denied
Date: Sat, 19 Apr 2008 20:21:17 +0200
Message-ID: <480A381D.3030908@sharp.fm> (raw)
In-Reply-To: <480A1A55.6090800@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>
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
- attempt to access /tmp/foo as the user postgres, at this point a user
logged in as postgres will be able to access the directory.
- attempt to create a tablespace on /tmp/foo, this will fail until
postgresql is restarted, after which the attempt will succeed.
Regards,
Graham
--
Attachments:
smime.p7s (application/x-pkcs7-signature, 3.2K) download
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: minfrin@sharp.fm, jd@commandprompt.com, tgl@sss.pgh.pa.us
Subject: Re: Could not create a tablespace - permission denied
In-Reply-To: <480A381D.3030908@sharp.fm>
* 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