From: | alexander lunyov <lan(at)zato(dot)ru> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | migrate data 6.5.3 -> 8.3.1 |
Date: | 2008-08-14 13:58:31 |
Message-ID: | 48A43A07.4090307@zato.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello everybody.
We have a dusty old server, FreeBSD 3.3-RELEASE, PostgreSQL 6.5.3.
I need to migrate four DBs from old server to new server (FreeBSD 6.2,
PostgreSQL 8.3.1).
I've tried to do pg_dump on old server, transfer it to new one and do
`psql -f dumpfile dbname`. Well, no surprise, then i see a lot of
warning and errors. Here they are (only unique error messages, they're
duplicated actually):
psql:dump:389: WARNING: aggregate attribute "sfunc2" not recognized
psql:dump:389: WARNING: aggregate attribute "stype2" not recognized
psql:dump:389: WARNING: aggregate attribute "initcond2" not recognized
psql:dump:389: ERROR: function int84div(bigint) does not exist
psql:dump:390: ERROR: function int4div(integer) does not exist
psql:dump:391: ERROR: function int2div(smallint) does not exist
psql:dump:392: ERROR: function float4div(real) does not exist
psql:dump:393: ERROR: function float8div(double precision) does not exist
psql:dump:394: ERROR: function cash_div_flt8(money) does not exist
psql:dump:395: ERROR: type "timespan" does not exist
psql:dump:396: ERROR: function numeric_div(numeric) does not exist
psql:dump:410: ERROR: function int4larger(abstime, abstime) does not exist
psql:dump:422: ERROR: function int4smaller(abstime, abstime) does not exist
psql:dump:413: ERROR: type "datetime" does not exist
psql:dump:429: ERROR: aggregate stype must be specified
How can i safely do this migration? Dumps of these four DBs is about
250Megs in sum.
--
alexander lunyov
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-08-14 14:04:35 | Re: WIP: patch to create explicit support for semi and anti joins |
Previous Message | Robert Haas | 2008-08-14 13:27:34 | Re: Join Removal/ Vertical Partitioning |