Re: upgrade to 7.2 & pgdumpall - Mailing list pgsql-general

From Tom Lane
Subject Re: upgrade to 7.2 & pgdumpall
Date
Msg-id 26606.1014131068@sss.pgh.pa.us
Whole thread Raw
In response to upgrade to 7.2 & pgdumpall  ("Ben-Nes Michael" <miki@canaan.co.il>)
List pgsql-general
"Ben-Nes Michael" <miki@canaan.co.il> writes:
> I ran:
> dumpall -o -h host > all_7.1.3-db.dump ( using the running server 7.1.3 )
> /usr/local/pg-7.2/bin/psql -p 5555 -d template1 -f ./all_7.1.3-db.dump
> (using the 7.2 psql)

> and got many errors, here is some examples:

> ERROR:  No such attribute or function 'oid'
> ERROR:  relation "pgadmin_checks" not found
> ERROR:  relation "pgadmin_groups" not found
> ERROR:  No such attribute or function 'indislossy'
> ERROR:  relation "pgadmin_indexes" not found

Looks like you've got a bunch of pgadmin tables and functions in there.
AFAIK, pgadmin is not compatible with 7.2.  You could try pgadmin II
instead.

            regards, tom lane

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: Re: OID question
Next
From: BELLON Michel
Date:
Subject: OID and 7.2 release