Postgres Pro
Downloads
Home   >   mailing lists

Re: truncate transaction log - Mailing list pgsql-general

From Simon Riggs
Subject Re: truncate transaction log
Date
Msg-id 1186509454.4192.10.camel@ebony.site
Whole thread Raw
In response to truncate transaction log  (Sergei Shelukhin <realgeek@gmail.com>)
Responses Re: truncate transaction log
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: finding reusable ids
Next
From: novnov
Date:
Subject: Reordering columns, will this ever be simple?