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