On 8/5/07, Sergei Shelukhin <realgeek@gmail.com> 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?