Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Edmund Horner <ejrh00(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP
Date: 2012-05-25 00:34:01
Message-ID: 20120525003401.GA25460@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugs
On Fri, May 25, 2012 at 11:48:53AM +1200, Edmund Horner wrote:
> It still fails (when run in verbose mode):
> 
>     Creating catalog dump
> ""c:\ehorner\pgsql\bin/pg_dumpall" --port 50432 --username "ehorner"
> --schema-only --binary-upgrade --verbose > "pg_upgrade_dump_all.sql"
> 2>> "pg_upgrade_utility.log""
>     ok
>     ""c:\ehorner\pgsql-old\bin/pg_ctl" -w -l "pg_upgrade_server2.log"
> -D "c:\ehorner\pgdata-old" -o""  stop >> "pg_upgrade_server2.log"
> 2>&1"
>     The process cannot access the file because it is being used by
> another process.
>     *failure*
>     There were problems executing """c:\ehorner\pgsql-old\bin/pg_ctl"
> -w -l "pg_upgrade_server2.log" -D "c:\ehorner\pgdata-old" -o ""  stop
> >> "pg_upgrade_server2.log" 2>&1""

Bingo, this is exactly where I expected it to fail.   I am attaching a
new, applied patch that creates files pg_upgrade_server_start.log and
pg_upgrade_server_stop.log to log the pg_ctl start/stop stdout
seperately.  This should fix the error.  Thanks so much for testing.  I
believe someone will generate a new binary for testing.

> I.e. I think pg_ctl wrote the last couple of lines, and then the two
> cmd.exe were unable to write anything more since presumably it's still
> open.
> 
> So is this the problem you predicted above with pg_ctl stop?

Yep, I think we are good now.  I never expected this behavior, but it
now makes sense.

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

  + It's impossible for everything to be true. +

Attachment: pg_upgrade.diff
Description: text/x-diff (4.9 KB)

In response to

Responses

pgsql-bugs by date

Next:From: ThangalinDate: 2012-05-25 00:37:54
Subject: Re: pg_dump: SQL command failed
Previous:From: Edmund HornerDate: 2012-05-24 23:52:39
Subject: Re: PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group