| 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 |
| Subject: | Re: upgrade to 7.2 & pgdumpall |
| Date: | 2002-02-19 15:04:28 |
| Message-ID: | 26606.1014131068@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-02-19 15:11:46 | Re: pg_dump correct version? |
| Previous Message | Doug McNaught | 2002-02-19 14:51:31 | Re: execute permissions of stored procedures? |