Re: [GENERAL] Creation of tablespaces

2010-01-15 Thread Aaron
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

Re: RE : [GENERAL] Creation of tablespaces

2010-01-15 Thread Tom Lane
=?iso-8859-1?Q?DURAND_Beno=EEt?= writes: > 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. That would be your problem then ... (It might not actually need r, but it definitely must have x, in orde

RE : [GENERAL] Creation of tablespaces

2010-01-15 Thread DURAND Benoît
:51 À : DURAND Benoît Cc : pgsql-general@postgresql.org Objet : Re: [GENERAL] Creation of tablespaces =?iso-8859-1?Q?DURAND_Beno=EEt?= 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 acce

Re: [GENERAL] Creation of tablespaces

2010-01-15 Thread Tom Lane
=?iso-8859-1?Q?DURAND_Beno=EEt?= 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 pos