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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, February 19, 2002 5:04 PM
Subject: Re: [GENERAL] upgrade to 7.2 & pgdumpall

> "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)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(at)postgresql(dot)org)
>