When upgrading from postgres 9.2 to 9.3 by following the upgrade procedure found in PostgreSQL 9.3.4 documentation about
pg_upgrade, the following command fails:
RUNAS /USER:postgres "CMD.EXE"
After some investigation, it seems there is no postgres windows user on the machine. This causes the
pg_upgrade command to fail as well.
How should I run the upgrade process?
Open an administrator cmd window as described in the link above.
Make sure you
cd into an empty writable folder (for example,
pg_upgrade command, and make sure to add an
-u postgres parameter to it:
"C:Program FilesPostgreSQL9.3binpg_upgrade.exe" -u postgres --old-datadir "C:/Program Files/PostgreSQL/9.2/data" --new-datadir "C:/Program Files/PostgreSQL/9.3/data" --old-bindir "C:/Program Files/PostgreSQL/9.2/bin" --new-bindir "C:/Program Files/PostgreSQL/9.3/bin"