Re: Creation of tablespaces

Ubuntu never shipped with selinux, it is available by installing the
"selinux" meta-package. Ubuntu does ship with AppArmor and loaded by
default in Hardy 8.04 and beyond but I don't believe there are any
PotgreSQL profiles.

Aaron Thul
http://www.chasingnuts.com

On Fri, Jan 15, 2010 at 10:51 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> =?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
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>