truncate transaction log

From: Sergei Shelukhin <realgeek(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: truncate transaction log
Date: 2007-08-05 10:45:15
Message-ID: 1186310715.175130.196870@g4g2000hsf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message RPK 2007-08-05 10:53:56 Re: WAL Queries
Previous Message Paul Lambert 2007-08-05 10:45:12 Re: WAL Queries