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

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 )

Le Mercredi 20 F�vrier 2002 10:12, Ben-Nes Michael a �crit :

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.

Dear Michael,

pgAdmin2 has its own abstraction layer called pgSchema. There are no
supplementary relations needed. So, do not hesitate to upgrade to pgAdmin2 at
http://pgadmin.postgresql.org.

Cheers,
Jean-Michel POURE

"Ben-Nes Michael" <miki@canaan.co.il> writes:

But still if it was legal relation in 7.1.3 why its not legal in 7.2 ?

pgadmin is making assumptions about the system catalog contents that
aren't true anymore in 7.2. Thus its views on the catalogs break.

Does pgadmin II install relations of its own in the DB too ?

I think they're views, not tables. Still, I agree that there's no
really good reason to have them. As for whether pgadmin II is less
intrusive, you'll have to go ask its developers.

regards, tom lane

Jean-Michel,
Just to make sure I'm not screwing something up, if I've started using
pgAdmin2 and stopped using pgAdmin, I can drop all the pgadmin_*
tables/views/functions/etc. from my databases with no ill effects, right?
Thanks,
Peter Darley

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Jean-Michel
POURE
Sent: Wednesday, February 20, 2002 1:58 AM
To: Ben-Nes Michael
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] upgrade to 7.2 & pgdumpall

Le Mercredi 20 F�vrier 2002 10:12, Ben-Nes Michael a �crit :

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.

Dear Michael,

pgAdmin2 has its own abstraction layer called pgSchema. There are no
supplementary relations needed. So, do not hesitate to upgrade to pgAdmin2
at
http://pgadmin.postgresql.org.

Cheers,
Jean-Michel POURE

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Le Mercredi 20 F�vrier 2002 20:24, Peter Darley a �crit :

Jean-Michel,
��������Just to make sure I'm not screwing something up, if I've started
using pgAdmin2 and stopped using pgAdmin, I can drop all the pgadmin_*
tables/views/functions/etc. from my databases with no ill effects, right?
Thanks,
Peter Darley

Yes, you can delete the pgadmin_* objects.
Regards,
Jean-Michel POURE