Search Postgresql Archives

Re: WAL archiving and deletion of the WAL segments

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On April 10, 2006 09:28 am, "Just Someone" <just.some@xxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux