gistfile1.bat

RUNAS /USER:postgres "CMD.EXE"
SET PATH=C:\Program Files\PostgreSQL\9.2\bin;%PATH%

pg_upgrade.exe --check --old-datadir "c:\ProgramData\PostgreSQL\9.1\data" --new-datadir "c:\ProgramData\PostgreSQL\9.2\data" --old-bindir "C:/Program Files/PostgreSQL/9.1/bin" --new-bindir "C:/Program Files/PostgreSQL/9.2/bin" --old-port 50431 --new-port 50432 --retain

gistfile2.txt

- use the same locale when creating new cluster
- give postgres user access to the new cluster data directory
- change pg_hba.conf auth method to trust for both clusters
- cwd to directory where postgres user has write permissions
- tablespace junction/symlinks may break. use dump/restore for problematic tables
- clean up old cluster and adjust new port in postgresql.conf