On 8/5/07, Sergei Shelukhin <realgeek@xxxxxxxxx> wrote: > Hi. > > 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? This sounds unusually high. What non-default settings are there in your postgresql.conf file? Are you using PITR or something like that? ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
