Removal of WAL logs

From: "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Removal of WAL logs
Date: 2012-01-04 12:00:56
Message-ID: A2E53AF8AE1C284C8F8B648653C0920B1D6A5766@EXXMAIL02.desktop.frd.metoffice.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Matthew Foster 2012-01-04 16:36:16 Strategy for doing number-crunching
Previous Message Thom Brown 2012-01-04 00:18:32 Re: error tryiing to insert with collate