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.
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 |