[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

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 folder

Re: [GENERAL] archive folder housekeeping

2013-08-09 Thread Ian Lawrence Barwick
2013/8/9 ascot.m...@gmail.com 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

Re: [GENERAL] archive folder housekeeping

2013-08-09 Thread Michael Paquier
On Fri, Aug 9, 2013 at 9:12 PM, Ian Lawrence Barwick barw...@gmail.com wrote: 2013/8/9 ascot.m...@gmail.com 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: