Re: Win32 Powerfail testing - Mailing list pgsql-hackers

From Dave Page
Subject Re: Win32 Powerfail testing
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B8259D1A@mail.vale-housing.co.uk
Whole thread Raw
In response to Win32 Powerfail testing  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: Win32 Powerfail testing  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers

> -----Original Message-----
> From: Tatsuo Ishii [mailto:t-ishii@sra.co.jp]
> Sent: 05 March 2003 13:49
> To: Dave Page
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Win32 Powerfail testing
>
>
> > > So far we found interesting facts. Our Win32 port passes his
> > > test in most cases. However if power of the machine is turned
> > > off right after (10 to 20 seconds) the Checkpoint has been
> > > made, it does not passes his test. So we are thinking that
> > > there is someting wrong with the checkpoint implementaion for
> > > Win32 port, which is essentially same as Jan's
> > > implementation. i.e. using _flushall() instead of sync().  We
> > > were looking for a fix or an alternative implementaion of
> > > sync() without success.
> >
> > Hi Tatsuo,
> >
> > Does this help:
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;66052
>
> Sorry, but it does not help. The page says we could use
> FlushFileBuffers() to sync the kernel buffer to the
> disk. Unfortunately, it requires a file descriptor to flush
> for its argument. Thus it could not be a replacement of
> sync(). Actually I have modified the buffer manager so that
> it remembers all file descriptors those have not been synced
> yet to the disk at the checkpoint time to sync them later.
> However I found this modification does not help at all with
> some reason I don't know.

How do you open the files (function, flags etc)?

Regards, Dave.


pgsql-hackers by date:

Previous
From: Justin Clift
Date:
Subject: Postgresql.org site outage
Next
From: Peter Eisentraut
Date:
Subject: Re: Who puts the Windows binaries on the FTP server?