pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql : Error: Cannot stat /pgdata/8.2/main
4+ messages / 4 participants
[nested] [flat]
* psql : Error: Cannot stat /pgdata/8.2/main
@ 2007-06-13 05:44 Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2007-06-13 13:45 ` Re: [GENERAL] psql : Error: Cannot stat /pgdata/8.2/main Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Joost Kraaijeveld @ 2007-06-13 05:44 UTC (permalink / raw)
To: pgsql-general@postgresql.org; +Cc: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [GENERAL] psql : Error: Cannot stat /pgdata/8.2/main
2007-06-13 05:44 psql : Error: Cannot stat /pgdata/8.2/main Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
@ 2007-06-13 13:45 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-06-13 14:42 ` Re: psql : Error: Cannot stat /pgdata/8.2/main Leif B. Kristensen <leif@solumslekt.org>
2007-06-14 02:02 ` Re: [GENERAL] psql : Error: Cannot stat /pgdata/8.2/main Pascal Hakim <pasc@linuxworld.com.au>
0 siblings, 2 replies; 4+ messages in thread
From: Tom Lane @ 2007-06-13 13:45 UTC (permalink / raw)
To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>; +Cc: pgsql-general@postgresql.org; pgsql-admin
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.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: psql : Error: Cannot stat /pgdata/8.2/main
2007-06-13 05:44 psql : Error: Cannot stat /pgdata/8.2/main Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2007-06-13 13:45 ` Re: [GENERAL] psql : Error: Cannot stat /pgdata/8.2/main Tom Lane <tgl@sss.pgh.pa.us>
@ 2007-06-13 14:42 ` Leif B. Kristensen <leif@solumslekt.org>
1 sibling, 0 replies; 4+ messages in thread
From: Leif B. Kristensen @ 2007-06-13 14:42 UTC (permalink / raw)
To: pgsql-general@postgresql.org
On Wednesday 13. June 2007 15:45, Tom Lane wrote:
>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.
FWIW, 'Cannot stat' is usually coming from the cp command, and indicates
that it can't find the source file.
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE
My Jazz Jukebox: http://www.last.fm/user/leifbk/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [GENERAL] psql : Error: Cannot stat /pgdata/8.2/main
2007-06-13 05:44 psql : Error: Cannot stat /pgdata/8.2/main Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2007-06-13 13:45 ` Re: [GENERAL] psql : Error: Cannot stat /pgdata/8.2/main Tom Lane <tgl@sss.pgh.pa.us>
@ 2007-06-14 02:02 ` Pascal Hakim <pasc@linuxworld.com.au>
1 sibling, 0 replies; 4+ messages in thread
From: Pascal Hakim @ 2007-06-14 02:02 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-admin; +Cc: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-06-14 02:02 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-13 05:44 psql : Error: Cannot stat /pgdata/8.2/main Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2007-06-13 13:45 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-06-13 14:42 ` Leif B. Kristensen <leif@solumslekt.org>
2007-06-14 02:02 ` Pascal Hakim <pasc@linuxworld.com.au>
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