Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e6LM6Qh60537; Fri, 21 Jul 2000 18:06:26 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id SAA25363; Fri, 21 Jul 2000 18:06:00 -0400 (EDT) To: John Burski cc: pgsql-admin@postgresql.org, pgsql-novice@postgresql.org Subject: Re: [NOVICE] pg_dump problem In-reply-to: <3978A6B0.BB13C40@autopartshq.com> References: <3978A6B0.BB13C40@autopartshq.com> Comments: In-reply-to John Burski message dated "Fri, 21 Jul 2000 14:38:24 -0500" Date: Fri, 21 Jul 2000 18:05:59 -0400 Message-ID: <25359.964217159@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200007/88 John Burski writes: > When I issue the "pg_dump jcon" (jcon being the database name, of > course) I receive the following error message: > getInherits(): SELECT failed It might be time to put this in the FAQ ;-). You're probably trying to run a 6.5 (or earlier?) pg_dump against a 7.0 database. The older pg_dump doesn't do any version checking, and the first it realizes it's got trouble is when it hits incompatibilities in the system table layout. Check your PATH to see where pg_dump is coming from... regards, tom lane