Re: Creation of tablespaces

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: DURAND Benoît <b(dot)durand(at)AFSSA(dot)FR>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Creation of tablespaces
Date: 2010-01-15 15:51:12
Message-ID: 28951.1263570672@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-1?Q?DURAND_Beno=EEt?= <b(dot)durand(at)AFSSA(dot)FR> writes:
> I work with Ubuntu 9.10 (upgraded from 8.04 LTS yesterday) and PostgreSQL 8.3.
> I can't create tablespaces. Pgsql seems to try changing access rights of the directory and fails to do it (permission denied), despite the directory is owned by the postgres user

Are you sure that postgres has r+x rights on all the directories above
that one?

If this were a Red Hat distro I would also wonder about selinux
permissions, but I don't know whether Ubuntu has selinux or enables
it by default.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message akp geek 2010-01-15 16:39:25 identify Tables without primary keys - postgres
Previous Message Scott Marlowe 2010-01-15 15:42:34 Re: Table name from directory