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@momjian.us>


> depstein@alliedtesting.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@momjian.us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>
>  + None of us is going to be here forever. +