Re: [NOVICE] pg_dump problem

From: John Burski <jburski(at)autopartshq(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] pg_dump problem
Date: 2000-07-22 14:16:43
Message-ID: 3979ACCB.C2CC2C@autopartshq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-novice

Just the ticket!! I renamed the old "pg_dump" command in /usr/bin and
created a symbolic link to the "pg_dump" command in /usr/local/pgsql/bin
and, voila!, life is good!

Thanks, Tom!

Tom Lane wrote:

> John Burski <jburski(at)autopartshq(dot)com> 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

--
John R. Burski - (Title depends on the hat I'm wearing)
Automotive Parts Headquarters, Inc.
125 South 29th Avenue
Saint Cloud, MN 56301
320 252 5411 x137

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas SMETS 2000-07-25 02:02:36 [Fwd: inserting integer in Table]
Previous Message Tom Lane 2000-07-21 22:05:59 Re: [NOVICE] pg_dump problem

Browse pgsql-novice by date

  From Date Subject
Next Message Robert B. Easter 2000-07-24 05:15:00 Is there any way to speed up PL/TCL functions?
Previous Message Guido Medina 2000-07-21 22:37:50 About jdbc:postgresql...