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

[GENERAL] Creation of tablespaces

2010-01-15 Thread DURAND Benoît
Hello, 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 Under the Ubuntu 8.04 LTS distri