Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl> 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