*** a/doc/src/sgml/pgupgrade.sgml --- b/doc/src/sgml/pgupgrade.sgml *************** *** 154,160 **** gmake prefix=/usr/local/pgsql.new install pg_ctl --pgdata /opt/PostgreSQL/8.4 stop ! pg_ctl --pgdata /opt/PostgreSQL/8.5 stop or on Windows --- 154,160 ---- pg_ctl --pgdata /opt/PostgreSQL/8.4 stop ! pg_ctl --pgdata /opt/PostgreSQL/9.0 stop or on Windows *************** *** 175,181 **** NET STOP pgsql-8.3 (different service name) --- 175,183 ---- Run pg_upgrade + + Always run the pg_upgrade binary in the new server, not the old one. pg_upgrade requires the specification of the old and new cluster's PGDATA and executable (/bin) directories. You can also specify separate *************** *** 192,198 **** NET STOP pgsql-8.3 (different service name) RUNAS /USER:postgres "CMD.EXE" ! SET PATH=%PATH%;C:\Program Files\PostgreSQL\8.5\bin; and then run pg_upgrade with quoted directories, e.g.: --- 194,200 ---- RUNAS /USER:postgres "CMD.EXE" ! SET PATH=%PATH%;C:\Program Files\PostgreSQL\9.0\bin; and then run pg_upgrade with quoted directories, e.g.: *************** *** 200,208 **** SET PATH=%PATH%;C:\Program Files\PostgreSQL\8.5\bin; pg_upgrade.exe --old-datadir "C:/Program Files/PostgreSQL/8.4/data" ! --new-datadir "C:/Program Files/PostgreSQL/8.5/data" --old-bindir "C:/Program Files/PostgreSQL/8.4/bin" ! --new-bindir "C:/Program Files/PostgreSQL/8.5/bin" Once started, pg_upgrade will verify the two clusters are compatible --- 202,210 ---- pg_upgrade.exe --old-datadir "C:/Program Files/PostgreSQL/8.4/data" ! --new-datadir "C:/Program Files/PostgreSQL/9.0/data" --old-bindir "C:/Program Files/PostgreSQL/8.4/bin" ! --new-bindir "C:/Program Files/PostgreSQL/9.0/bin" Once started, pg_upgrade will verify the two clusters are compatible