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
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
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
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: