pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Pascal Hakim <pasc@linuxworld.com.au>
To: pgsql-general@postgresql.org
To: pgsql-admin@postgresql.org
Cc: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
Subject: Re: [GENERAL] psql : Error: Cannot stat /pgdata/8.2/main
Date: Thu, 14 Jun 2007 12:02:02 +1000
Message-ID: <20070614020202.GS15526@idg.com.au> (raw)
In-Reply-To: <9233.1181742352@sss.pgh.pa.us>
References: <1181713452.3856.12.camel@panoramix>
	<9233.1181742352@sss.pgh.pa.us>

On Wed, Jun 13, 2007 at 09:45:52AM -0400, Tom Lane wrote:
> 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.
> 

It shows up a couple of times in the Debian wrapper scripts, when it's
trying to figure out which socket to actually connect to. It only gets
there after giving up on reading postgresql.conf and after giving up on
/var/run/postgresql. From the bug Joost filed in the Debian bts[1], it
looks like the Debian upgrade script got confused somehow.

Cheers,

Pasc

[1]: http://bugs.debian.org/428698
--
Pascal Hakim
Do not bend



view thread (4+ messages)

Message-ID: <20070614020202.GS15526@idg.com.au>
Permalink:  ../20070614020202.GS15526@idg.com.au/
Also on:    postgresql.org/message-id/20070614020202.GS15526@idg.com.au

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: pasc@linuxworld.com.au, pgsql-general@postgresql.org, J.Kraaijeveld@Askesis.nl
  Subject: Re: [GENERAL] psql : Error: Cannot stat /pgdata/8.2/main
  In-Reply-To: <20070614020202.GS15526@idg.com.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox