| From: | Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | psql : Error: Cannot stat /pgdata/8.2/main |
| Date: | 2007-06-13 05:44:12 |
| Message-ID: | 1181713452.3856.12.camel@panoramix |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-06-13 13:45:52 | Re: [GENERAL] psql : Error: Cannot stat /pgdata/8.2/main |
| Previous Message | Adam Tauno Williams | 2007-06-12 17:46:07 | Re: A question about memory usage |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2007-06-13 06:53:16 | Re: how to speed up query |
| Previous Message | Steve Atkins | 2007-06-13 03:26:25 | Re: PostGreSQL for a small Desktop Application |