Postgres Pro
Downloads
Home   >   mailing lists

Thread: WAL archiving and deletion of the WAL segments

WAL archiving and deletion of the WAL segments

From
"Just Someone"
Date:
I implemented wal archiving and it seems to be working. The segments
are being copied by the shell script, and in the pg_log file I see
this line:

LOG:  archived transaction log file "000000010000001D00000096"

But the file is still int he pg_xlog directory. In the documentation I
read that it might either delete or recycle the segment files. As I
still see it in the directory, I want to make absolutely sure my
archiving is working correctly.

So my question is: Is what I'm seeing meaning the WAL archiving is
working? Or should I expect the file to be deleted?

Bye,

Guy.


--
Family management on rails: http://www.famundo.com - coming soon!
My development related blog: http://devblog.famundo.com

Re: WAL archiving and deletion of the WAL segments

From
Alan Hodgson
Date:
On April 10, 2006 09:28 am, "Just Someone" <just.some@gmail.com> wrote:
> I implemented wal archiving and it seems to be working. The segments
> are being copied by the shell script, and in the pg_log file I see
> this line:
>
> LOG:  archived transaction log file "000000010000001D00000096"
>
> But the file is still int he pg_xlog directory. In the documentation I
> read that it might either delete or recycle the segment files. As I
> still see it in the directory, I want to make absolutely sure my
> archiving is working correctly.
>
> So my question is: Is what I'm seeing meaning the WAL archiving is
> working? Or should I expect the file to be deleted?
>

If the file is showing up in your archive target location, it's working.
The file will remain in the pg_xlog directory for some time, and then
eventually be recycled.  Based on the message, I would say it's working
fine.


--
Alan

Re: WAL archiving and deletion of the WAL segments

From
Tom Lane
Date:
Alan Hodgson <ahodgson@simkin.ca> writes:
> On April 10, 2006 09:28 am, "Just Someone" <just.some@gmail.com> wrote:
>> So my question is: Is what I'm seeing meaning the WAL archiving is
>> working? Or should I expect the file to be deleted?

> If the file is showing up in your archive target location, it's working.
> The file will remain in the pg_xlog directory for some time, and then
> eventually be recycled.

I'd expect the file to be renamed or deleted at the next checkpoint, so
"eventually" is not very long, unless you've increased the checkpoint
spacing parameters quite a lot ...

            regards, tom lane