psql : Error: Cannot stat /pgdata/8.2/main - Mailing list pgsql-admin

From Joost Kraaijeveld
Subject psql : Error: Cannot stat /pgdata/8.2/main
Date
Msg-id 1181713452.3856.12.camel@panoramix
Whole thread Raw
Responses Re: [GENERAL] psql : Error: Cannot stat /pgdata/8.2/main  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Adam Tauno Williams
Date:
Subject: Re: A question about memory usage
Next
From: Arnau Rebassa i Villalonga
Date:
Subject: A question about memory usage