Hi List
I'm on 8.4.5 in WAL mode with a database that has a low transaction rate and will probably be running nightly backups.
Is there a recommendation for how many WAL logs I should keep on disk in pg_xlog and also how many to keep on external tape?
Are there any simple scripts/procedures that will mange the WAL logs and in particular delete them from pg_xlog when they are no longer needed so that they don't fill up the disk?
Thanks
Austen