Joost Kraaijeveld <[EMAIL PROTECTED]> writes: > I have moved my database files 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 > /pgdata/8.2/main is the location where the database files are actually > located. psql itself has no business touching the database directory, and a quick search of the source code shows no instance of "Cannot stat" anywhere in released PG sources. I think you are being burnt by some misbehavior of Debian's wrapper patches, and a complaint directed there is the next step for you. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq