reassign 428698 postgresql-common 75 retitle 428698 psql aborts with stat failure severity 428698 normal thanks
Hi Joost, 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). Joost Kraaijeveld [2007-06-13 17:37 +0200]: > After upgrading from PostgreSQL 8.1 according to the instructions in > the Debian.README I cannot start psql any more. How did you do the upgrade? With pg_upgradecluster? Please show me the output of pg_lsclusters. > I had moved my database files in 8.1 from their default location to their own > partition on with their own controller and disks. PostgreSQL works OK > and I can connect with Pgadmin (Debian Lenny AMD64, PostgreSQL 8.2.4). > > When I want to connect with psql however (with a non-root account) I get > the following: > > panoramix:~$ psql -d my_database > Error: Cannot stat /pgdata/8.2/main It seems that /pgdata/8.2 cannot be read at all by normal users? What does ls -l /pgdata/ ls -ld /pgdata/8.2 ls -l /pgdata/8.2 say as your user? Did you create these directories and permissions manually? To fix this, you should change the permissions so that /pgdata/* is world-readable: chown 755 /pgdata /pgdata/* NB that the actual cluster directories (such as /pgdata/8.2/main) do not need to be world readable. Thanks, Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org
signature.asc
Description: Digital signature
