Re: upgrade to 7.2 & pgdumpall

Amazing, I didn't knew that pgadmin install tables & function in my DB & I
don't really like it.

But still if it was legal relation in 7.1.3 why its not legal in 7.2 ?
And what with the oid error ?

Does pgadmin II install relations of its own in the DB too ?
That strange as client suppose to be passive toward the server.

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Ben-Nes Michael" <miki@canaan.co.il>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, February 19, 2002 5:04 PM
Subject: Re: [GENERAL] upgrade to 7.2 & pgdumpall


> "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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>