Postgres Pro
Downloads
Home   >   mailing lists

Removal of WAL logs - Mailing list pgsql-novice

From Birchall, Austen
Subject Removal of WAL logs
Date
Msg-id A2E53AF8AE1C284C8F8B648653C0920B1D6A5766@EXXMAIL02.desktop.frd.metoffice.com
Whole thread Raw
Responses Re: Removal of WAL logs  (Josh Kupershmidt <schmiddy@gmail.com>)
List pgsql-novice
Tree view

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

pgsql-novice by date:

Previous
From: Thom Brown
Date:
Subject: Re: error tryiing to insert with collate
Next
From: Matthew Foster
Date:
Subject: Strategy for doing number-crunching