Hi Martin, Thanks for the answer.
On Wed, 2007-06-20 at 18:12 +0200, Martin Pitt wrote: > I downgrade the severity since this only affects a particular > non-default configuration and thus does not meet the defintion of > 'grave' (rendering package unusable for everyone). OK. > How did you do the upgrade? With pg_upgradecluster? I followed the readme: 1. apt-get install postgresql-8.2 2. pg_dropcluster 8.2 main --stop 3. pg_upgradecluster 8.1 main 4. Adjusted the postgresql.conf 5. Restart postgresql > > Please show me the output of pg_lsclusters. pg_lsclusters Version Cluster Port Status Owner Data directory Log file 8.2 main 5432 online postgres /pgdata/8.2/main /var/log/postgresql/postgresql-8.2-main.log > It seems that /pgdata/8.2 cannot be read at all by normal users? What > does > > ls -l /pgdata/ ls -l /pgdata total 0 drwx------ 3 postgres postgres 17 Jun 8 05:09 8.2 > ls -ld /pgdata/8.2 ls -ld /pgdata drwxr-xr-x 3 root root 16 Jun 13 07:13 /pgdata > ls -l /pgdata/8.2 ls -l /pgdata/8.2/ ls: /pgdata/8.2/: Permission denied > > say as your user? Did you create these directories and permissions > manually? Yes, I did this a long time ago (and to be honest: I can't remember how I did it *exactly*) > To fix this, you should change the permissions so that > /pgdata/* is world-readable: > > chown 755 /pgdata /pgdata/* ??? chmod 755 /pgdata /pgdata/*? This seems to do the trick. I did not use psql a lot (mostly doing everything by PgAmin) but I definitely remember using psql successfully before the upgrade. -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 web: www.askesis.nl -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]