From: | DURAND Benoît <b(dot)durand(at)AFSSA(dot)FR> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Tablespace creation |
Date: | 2010-01-15 15:28:27 |
Message-ID: | 8C4256AAE0B2BB4394C0E06970AC207447067C279A@SALFEXCHBAL.afssa.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 distribution I had no problem with table spaces...
Any idea ?
bdurand(at)bdurand-desktop:/var/lib/postgresql/8.3$ sudo psql template1 -U postgres
Mot de passe pour l'utilisateur postgres :
Bienvenue dans psql 8.3.8, l'interface interactive de PostgreSQL.
Saisissez:
\copyright pour les termes de distribution
\h pour l'aide-mémoire des commandes SQL
\? pour l'aide-mémoire des commandes psql
\g ou point-virgule en fin d'instruction pour exécuter la requête
\q pour quitter
template1=# create tablespace lacie owner bdurand location '/media/DD_LaCie/postgres/8.3';
ERREUR: n'a pas pu configurer les droits du répertoire « /media/DD_LaCie/postgres/8.3 » : Permission non accordée
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-01-15 15:29:17 | Re: vacuum issues under load? |
Previous Message | Ben Chobot | 2010-01-15 15:08:57 | Re: vacuum issues under load? |