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 [...@sss.pgh.pa.us]
Date d'envoi : vendredi 15 janvier 2010 16:51
À : DURAND Benoît
Cc : pgsql-general@postgresql.org
Objet : Re: [GENERAL] Creation of tablespaces
=?iso-8859-1?Q?DURAND_Beno=EEt?= <b.dur...@afssa.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
