Messages posted by: serafin_s

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.

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.

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