upgrade to 7.2 & pgdumpall - Mailing list pgsql-general

From Ben-Nes Michael
Subject upgrade to 7.2 & pgdumpall
Date
Msg-id 018d01c1b93c$2a4c3be0$aa0f5ac2@canaan.co.il
Whole thread Raw
Responses Re: upgrade to 7.2 & pgdumpall
List pgsql-general
Hi All

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

I browsed the tables briefly ( on the 7.2 ) and it seemed ok.
is it ok ?

--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------



pgsql-general by date:

Previous
From: Holger Marzen
Date:
Subject: Re: Selectively compile psql
Next
From: pilsl@goldfisch.at
Date:
Subject: pgsql->ms excel