Windows instructions are incomplete

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: stefan(dot)badenhorst(at)mi-c3(dot)com
Subject: Windows instructions are incomplete
Date: 2018-01-31 11:57:56
Message-ID: 151739987665.1235.12344875501039377952@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2018-01-31 21:44:01 Re: Bug in pg_upgrade standby rsync doc
Previous Message Peter Eisentraut 2018-01-31 04:02:04 Re: removal of md5 from example code