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
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 |
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... |