pg_migrator

postgredsql 8.3.7/8.4 on windows server 2003 on hp ml350 quad core xeon 4gb ram

i was trying to migrate from 8.3.7 to 8.4 using the pg_migrator. i did basically what the install file says by copying
pg_migrator.dll to C:\Program Files\PostgreSQL\8.4\lib
pg_migrator.exe to "C:\Program Files\PostgreSQL\8.4\bin
and running
NET STOP pgsql-8.3
NET STOP postgresql-8.4
c:\windows\system32\pg_migrator -d "c:\program files\postgresql\8.3\data" -D "c:\program files\postgresql\8.4.data" -b "c:\program files\postgresql\8.3\bin" -B "c:\program files\postgresql\8.4\bin" -l "c:\log\logfile.txt"
below is the logged results:

Performing consistency checks
-----------------------------
Checking old data directory c:\program files\postgresql\8.3\data
checking base ok
checking global ok
checking pg_clog ok
checking pg_multixact ok
checking pg_subtrans ok
checking pg_tblspc ok
checking pg_twophase ok
checking pg_xlog ok
Checking new data directory c:\program files\postgresql\8.4\data
checking base ok
checking global ok
checking pg_clog ok
checking pg_multixact ok
checking pg_subtrans ok
checking pg_tblspc ok
checking pg_twophase ok
checking pg_xlog ok
Checking binaries in old cluster (c:\program files\postgresql\8.3\bin)
checking postgres ok
checking pg_ctl ok
checking pg_dumpall ok
Checking binaries in new cluster (c:\program files\postgresql\8.4\bin)
checking postgres ok
checking pg_ctl ok
checking pg_dumpall ok
checking psql ok

pg_migrator.dll must be created and installed in c:/PROGRA~1/POSTGR~1/8.4/lib/pg_migrator.dll

nothing else happened aside from the above.

is there anything i've missed. your help would be greatly appreciated.

thanks and regards.

raffy segador
destiny cable inc
ncr, philippines

scratch that. it seems i copied pg_migrator.dll to C:\Program Files\PostgreSQL\8.4\bin instead of C:\Program Files\PostgreSQL\8.4\lib.

thanks.

it seems that i am not out of the woods yet. i reran the above script and i got the following log entries:

Checking binaries in new cluster (c:\program files\postgresql\8.4\bin)
checking postgres ok
checking pg_ctl ok
checking pg_dumpall ok
checking psql ok
old and new pg_controldata date/time storage types do not match

You will need to rebuild the new server with configure
--disable-integer-datetimes or get server binaries built with those options.

I have no idea how this last log entry could be done. help please.

Are you using PostgresPlus, or open-source PG?