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

Re: Half filled xlogs

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>,<pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: Half filled xlogs
Date: 2005-03-20 16:02:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers-win32
>I'm looking into copying partially filled xlogs with the Archiver
>process, to allow a more rounded warm standby database option.
>My understanding is that on win32, when an xlog file is still being
>written to by a backend it will be locked and unable to be copied away
>by another process.

No, that shouldn't be a problem. We open all our files with
should work fine as the other process that reads it also opens it with

To verify, I started up a backend and did a begin transaction;create
table foo(bar int);
Then I copied the xlog file, and it copied without any errors. 

AFAIK, it shuold also contain the actual data, as long as it's been
synced (which would be the same on unix, right?). (or if the file is
opened with o_dsync). I haven't verified it myself, though.



pgsql-hackers-win32 by date

Next:From: Tom LaneDate: 2005-03-20 17:42:58
Subject: Re: explain analyze timings
Previous:From: John A MeinelDate: 2005-03-20 16:01:39
Subject: Re: explain analyze timings

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