Re: [GENERAL] archive folder housekeeping

2013-08-09 Thread Michael Paquier
On Fri, Aug 9, 2013 at 9:12 PM, Ian Lawrence Barwick wrote: > 2013/8/9 ascot.m...@gmail.com : >> Is there any PG manual command available to remove archived files by >> (archive) date/time? > > pg_archivecleanup might be of use to you: > > http://www.postgresql.org/docs/current/static/pgarchive

Re: [GENERAL] archive folder housekeeping

2013-08-09 Thread Ian Lawrence Barwick
2013/8/9 ascot.m...@gmail.com : > Is there any PG manual command available to remove archived files by > (archive) date/time? pg_archivecleanup might be of use to you: http://www.postgresql.org/docs/current/static/pgarchivecleanup.html Regards Ian Barwick -- Sent via pgsql-general mailing

Re: [GENERAL] archive folder housekeeping

2013-08-09 Thread Albe Laurenz
ascot.m...@gmail.com wrote: > I have enabled archive in PG (v 9.2.4): > > archive_mode = on > archive_command = 'test ! -f /usr/local/pgsql/data/archive/%f && cp %p > /usr/local/pgsql/data/archive/%f' > > I know that pg_xlog folder is maintained by PostgreSQL automatically, when > the pg_xlog f

[GENERAL] archive folder housekeeping

2013-08-09 Thread ascot.m...@gmail.com
Hi, I have enabled archive in PG (v 9.2.4): archive_mode = on archive_command = 'test ! -f /usr/local/pgsql/data/archive/%f && cp %p /usr/local/pgsql/data/archive/%f' I know that pg_xlog folder is maintained by PostgreSQL automatically, when the pg_xlog folder hits to certain limit (pg_xlog