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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
