Re: pg_upgrade issues - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: pg_upgrade issues
Date
Msg-id 201006220506.o5M56Qp04407@momjian.us
Whole thread Raw
In response to pg_upgrade issues  (<depstein@alliedtesting.com>)
List pgsql-bugs
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
issuescame 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. +

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Bug in PL/pgSQL FOR cursor variant
Next
From: "Hiroshi Saito"
Date:
Subject: Re: pg_upgrade issues