RE : Creation of tablespaces

The directory is on another (external) disk, mounted under /media. Postgres has not r+x rights on that directory (or on /) which belong to root.
regards,
Benoit Durand
________________________________________
De : Tom Lane [tgl(at)sss(dot)pgh(dot)pa(dot)us]
Date d'envoi : vendredi 15 janvier 2010 16:51
À : DURAND Benoît
Cc : pgsql-general(at)postgresql(dot)org
Objet : Re: [GENERAL] Creation of tablespaces

=?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