Re: pg_upgrade issues

depstein(at)alliedtesting(dot)com wrote:
BBBBBB> PostgreSQL 9.0 beta 2
> Windows XP Professional SP2
>
> While migrating the database from 8.4 to 9.0 using pg_upgrade (now part of the Postgres project), the following issues came up:
>
> 1. When using the --logfile option, pg_upgrade quits with an error like this:
>
> The process cannot access the file because it is being used by another process.
>
> There were problems executing ""C:\PostgreSQL\8.4\bin/pg_ctl" -l "pg_upgrade.log
> " -D "D:\PostgreSQL84_matlab1b" -o "-p 5432 -c autovacuum=off -c autovacuum_free
> ze_max_age=2000000000" start >> "pg_upgrade.log" 2>&1"

Hiroshi, can you comment on the above bug report? I was able to
reproduce this on XP. I think we added -l for Win32 because the code
says:

/* use -l for Win32 */
snprintf(cmd, sizeof(cmd),
SYSTEMQUOTE "\"%s/pg_ctl\" -l \"%s\" -D \"%s\" "

but I don't remember the details, and cvs.pgfoundry.org is down right
now. Thanks.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ None of us is going to be here forever. +