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

On Thu, May 24, 2012 at 03:42:25PM +0200, Magnus Hagander wrote:
> On Thu, May 24, 2012 at 2:40 AM, Edmund Horner <ejrh00(at)gmail(dot)com> wrote:
> > On 24 May 2012 12:33, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> >> I have applied the attached patch which should fix the problem.   How
> >> can we get Edmund a copy of a new binary for testing?  Does he have to
> >> wait for beta2?
> >
> > My uneducated guess is that your patch will fix the problem.
> >
> > But I don't think I'm up to compiling it myself.  If someone reputable
> > can send me a new pg_upgrade.exe binary I'm happy to run it.
>
> I've built a new one off git master + Bruce's patch. You can get it
> from http://www.hagander.net/tmp/pg_upgrade.zip - please see if that
> one works for you.

Thanks, but thinking more, I am more concerned. Here is what we think
is happening (ah, flashbacks to the PG Windows port):

pg_ctl start > file1
pg_dumpall > file1
pg_ctl stop > file1

generates a file share error for pg_dump. I have replaced that with:

pg_ctl start > file2
pg_dumpall > file1
pg_ctl stop > file2

I am now concerned that 'pg_ctl stop' is going to give us a share
violation. The fix will be to use 'file3' for pg_ctl stop. Can I get
an updated report to see if that is accurate? Thanks.

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

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