Re: migrate data 6.5.3 -> 8.3.1 - Mailing list pgsql-hackers

Andreas Pflug wrote:
>>>> I want to try new pg_dump to connect to old server, but i can't - old
>>>> postgres doesn't listening to network socket. Why postgres 6.5.3 not
>>>> binding to network socket? It started with this line: 
> 
> Maybe you should just dump schema and data separately with your old 
> pg_dump tool, then rework the schema for 8.3 manually.

I can do this, but i don't know how to rework it.

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

If i understand it right, much of this errors are about AGGREGATEs (they 
are a part of schema):

CREATE AGGREGATE avg ( BASETYPE = int8,  SFUNC1 = int8pl, STYPE1 = int8, 
INITCOND1 = '', SFUNC2 = int4inc, STYPE2 = int4, INITCOND
2 = '0', FINALFUNC = int84div );

CREATE AGGREGATE avg ( BASETYPE = int4,  SFUNC1 = int4pl, STYPE1 = int4, 
INITCOND1 = '', SFUNC2 = int4inc, STYPE2 = int4, INITCOND
2 = '0', FINALFUNC = int4div );

CREATE AGGREGATE avg ( BASETYPE = int2,  SFUNC1 = int2pl, STYPE1 = int2, 
INITCOND1 = '', SFUNC2 = int2inc, STYPE2 = int2, INITCOND
2 = '0', FINALFUNC = int2div );

CREATE AGGREGATE avg ( BASETYPE = float4,  SFUNC1 = float4pl, STYPE1 = 
float4, INITCOND1 = '', SFUNC2 = float4inc, STYPE2 = float4
, INITCOND2 = '0.0', FINALFUNC = float4div );

CREATE AGGREGATE avg ( BASETYPE = float8,  SFUNC1 = float8pl, STYPE1 = 
float8, INITCOND1 = '', SFUNC2 = float8inc, STYPE2 = float8
, INITCOND2 = '0.0', FINALFUNC = float8div );

CREATE AGGREGATE avg ( BASETYPE = money,  SFUNC1 = cash_pl, STYPE1 = 
money, INITCOND1 = '', SFUNC2 = float8inc, STYPE2 = float8, I
NITCOND2 = '0.0', FINALFUNC = cash_div_flt8 );

CREATE AGGREGATE avg ( BASETYPE = timespan,  SFUNC1 = timespan_pl, 
STYPE1 = timespan, INITCOND1 = '', SFUNC2 = float8inc, STYPE2 = float8, INITCOND2 = '0.0', FINALFUNC = timespan_div );

CREATE AGGREGATE avg ( BASETYPE = numeric,  SFUNC1 = numeric_add, STYPE1 
= numeric, INITCOND1 = '', SFUNC2 = numeric_inc, STYPE2 = numeric, INITCOND2 = '0', FINALFUNC = numeric_div );

So, i have to replace these float4div to some new equivalent? And where 
can i find those equivalents for all these functions and special words, 
that "doesn't exists"?

-- 
alexander lunyov