public inbox for [email protected]
help / color / mirror / Atom feedFrom: PG Doc comments form <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Problems with pg_upgrade under Windows
Date: Thu, 15 Mar 2018 13:55:09 +0000
Message-ID: <[email protected]> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/pgupgrade.html
Description:
The postgresql service (since 9.x?) runs under Windows with the integrated
NetworkService account and not with a dedicated postgres account anymore (at
least by using the EnterpriseDB installer).
You can't start a shell as NetworkService (which seems not to be necessary).
But the owner and permissions of the data directory should be checked and
changed afterwards if necessary.
Another problem (not directly of pg_upgrade) is, that pg_upgrade internally
uses xcopy.exe to copy the pg_clog/pg_xact directory. Now, if somebody
redirects the standard output of pg_upgrade.exe but NOT the standard input,
xcopy failes silently and the pg_xact directory (or files within) are
missing.
This is a problem of xcopy.exe, apparently fixed on newer versions of
Windows but existent under Windows 7 x64. After many hours of testing and
searching, I finally found the cause of the failure here:
http://social.msdn.microsoft.com/Forums/en-US/netfxbcl/thread/ab3c0cc7-83c2-4a86-9188-40588b7d1a52/
I can confirm, that redirecting also the standard input of pg_upgrade.exe
solves the problem.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Problems with pg_upgrade under Windows
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox