Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9A6409FB7F2; Wed, 13 Jun 2007 02:44:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 26357-05; Wed, 13 Jun 2007 02:44:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from obelix.askesis.nl (laudanum.demon.nl [82.161.125.16]) by postgresql.org (Postfix) with ESMTP id 904059FB391; Wed, 13 Jun 2007 02:44:17 -0300 (ADT) Received: obelix 172.31.0.1 from 172.31.1.1 172.31.1.1 via HTTP with MS-WebStorage 6.0.6249 Received: from panoramix by obelix; 13 Jun 2007 07:44:13 +0200 Subject: psql : Error: Cannot stat /pgdata/8.2/main From: Joost Kraaijeveld To: pgsql-general@postgresql.org Cc: pgsql-admin@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Wed, 13 Jun 2007 07:44:12 +0200 Message-Id: <1181713452.3856.12.camel@panoramix> Mime-Version: 1.0 X-Mailer: Evolution 2.6.3 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.166 tagged_above=0 required=5 tests=AWL=0.029, BAYES_50=0.001, FORGED_RCVD_HELO=0.135, UNPARSEABLE_RELAY=0.001 X-Spam-Level: X-Archive-Number: 200706/106 X-Sequence-Number: 25774 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