Re: truncate transaction log

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