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
