Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_xlog/archive_status clean up - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: pg_xlog/archive_status clean up
Date
Msg-id CAGDYbUPbFTsMurb7yZPdintYORnQZsiSSfhXxjwcLGzydixjVw@mail.gmail.com
Whole thread Raw
In response to pg_xlog/archive_status clean up  (Ramiro Barreca <rbarreca@gmail.com>)
Responses Re: pg_xlog/archive_status clean up  (Ramiro Barreca <rbarreca@gmail.com>)
List pgsql-admin
Tree view


On Tue, Jan 9, 2018 at 4:58 PM, Ramiro Barreca <rbarreca@gmail.com> wrote:
At this moment I can see there are over 1.3 million "*.done" files at pg_xlog/archive_status folder.
The first ones are there since 2013.
As you may suppose this server has been rebooted several times since then. And daily backups are generated.
Is it safe to remove the old ones manually without exposing data lost? 
What about to hold only last month ones?
I think so but it would be better to have your approval.

​It looks like there is an issue with your archive destination where these archives file accumlated under archive_status are not getting copied, hence they are not cleaned up automatically by PostgreSQL behavour & we dont' recommend to remove them manully as these get cleaned up when u resolve your archive destination.

Note: We highly recommend to review your environment from the PostgreSQL side​


Ramiro Barreca
rbarreca@gmail.com



--
http://www.shreeyansh.com

pgsql-admin by date:

Previous
From: Ramiro Barreca
Date:
Subject: pg_xlog/archive_status clean up
Next
From: Damir Colak
Date:
Subject: pgAdmin Import/export does not show a progress dialog on mac