Thread: Windows instructions are incomplete

Windows instructions are incomplete

From
PG Doc comments form
Date:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/pgupgrade.html
Description:

In set 9. Run pg_upgrade:
It says that windows users should execute this:
RUNAS /USER:postgres "CMD.EXE"

This step does not work unless you create a user called postgres in windows
user management.

Furthermore, the instructions that follow do not work unless you:
1. Add the user to the administrators user group.
2. Give "full control" permission to the postgresql data folders on both the
old and new installations.

I have also found that it is easier to add localhost with "trust" in the
pg_hba.conf while you do the upgrade. Once completed, remove it again.