Re: pg_upgrade issues

Hi.

Ooops, I can't follow your quick thread....
sorry, It will be a weekend if allowed.

Regards,
Hiroshi Saito

----- Original Message -----
From: "Bruce Momjian" <bruce(at)momjian(dot)us>

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