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?
pgsql-novice by date
|Next:||From: Matthew Foster||Date: 2012-01-04 16:36:16|
|Subject: Strategy for doing number-crunching|
|Previous:||From: Thom Brown||Date: 2012-01-04 00:18:32|
|Subject: Re: error tryiing to insert with collate|