Re: truncate transaction log

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Sergei Shelukhin" <realgeek(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: truncate transaction log
Date: 2007-08-07 17:57:34
Message-ID: 1186509454.4192.10.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 2007-08-05 at 03:45 -0700, Sergei Shelukhin wrote:

> Is there any way to truncate WAL log in postgres?
> We want to use full-backup strategy where we stop the server and copy
> the data directory, however WAL log is taking dozens gigabytes of
> spaces.
> Is there any way to remove it while keeping the database operational/
> restore-able by copying it back?

Reduce the setting of checkpoint_segments to something more realistic.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message novnov 2007-08-07 18:07:39 Reordering columns, will this ever be simple?
Previous Message Michael Glaesemann 2007-08-07 17:30:58 Re: finding reusable ids