Re: does wal archiving block the current client connection? - Mailing list pgsql-admin

From Jeff Frost
Subject Re: does wal archiving block the current client connection?
Date
Msg-id Pine.LNX.4.64.0605172140440.7012@discord.home.frostconsultingllc.com
Whole thread Raw
In response to Re: does wal archiving block the current client connection?  (Jeff Frost <jeff@frostconsultingllc.com>)
List pgsql-admin
On Wed, 17 May 2006, Jeff Frost wrote:

> On Wed, 17 May 2006, Tom Lane wrote:
>
>> Did you try generating a test case using a long sleep() as a replacement
>> for the archive_command script?  If there is a PG bug here it shouldn't
>> be that hard to expose it in a simple test case.  I'm up to my armpits
>> in other stuff and don't have time to try it myself...
>
> Interesting that you should say that as I had just started setting up a test.
> I seem to get alot of these:
>
> May 17 21:34:04 discord postgres[20573]: [4-1] LOG:  archived transaction log
> file "000000010000000000000001"
> May 17 21:34:04 discord postgres[20573]: [5-1] WARNING:  could not rename
> file "pg_xlog/archive_status/000000010000000000000001.ready" to
> May 17 21:34:04 discord postgres[20573]: [5-2]
> "pg_xlog/archive_status/000000010000000000000001.done": No such file or
> directory
>
> I'm guessing that the archiver moves the WAL file to <wal filename>.ready,
> and successful completion, it renames it to <wal filename>.done?

Oh, except that they are 0 bytes, so they must be just status files.
Nevermind on that question. :-)


--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

pgsql-admin by date:

Previous
From: Jeff Frost
Date:
Subject: Re: does wal archiving block the current client connection?
Next
From: Tom Lane
Date:
Subject: Re: does wal archiving block the current client connection?