Problems with pg_upgrade under Windows

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Problems with pg_upgrade under Windows
Дата
Msg-id 152112210959.1217.7911406465826869349@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-docs
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.

В списке pgsql-docs по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT
Следующее
От: Euler Taveira
Дата:
Сообщение: Re: Can we only add values to enums?