Hi,
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.
Why do I get this error and what should I do to be able to connect to
the database?
TIA
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl