Hi Joost, Joost Kraaijeveld [2007-06-20 19:36 +0200]: > > 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
OK, that looks good. > > > 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 That would explain it. > > To fix this, you should change the permissions so that > > /pgdata/* is world-readable: > > > > chown 755 /pgdata /pgdata/* > ??? chmod 755 /pgdata /pgdata/*? Erk, of course chmod. Sorry. > 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. Hmm, that's strange. The upgrade process is not supposed to change directory permissions. Anyway, I'll reproduce your setup and upgrade here and check for this. Maybe I can eliminate the need for stat'ing the data directory from psql, I guess it is only used for consistency checks. Thank you! Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]