Re: [ADMIN] [GENERAL] psql : Error: Cannot stat /pgdata/8.2/main
On Wed, Jun 13, 2007 at 09:45:52AM -0400, Tom Lane wrote: > Joost Kraaijeveld <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] psql : Error: Cannot stat /pgdata/8.2/main
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/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] psql : Error: Cannot stat /pgdata/8.2/main
Joost Kraaijeveld <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] psql : Error: Cannot stat /pgdata/8.2/main
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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
