Re: [GENERAL] truncate transaction log

2007-08-09 Thread Sergei Shelukhin
On Aug 7, 9:57 pm, [EMAIL PROTECTED] ("Simon Riggs") wrote: > 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

Re: [GENERAL] truncate transaction log

2007-08-07 Thread Simon Riggs
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

Re: [GENERAL] truncate transaction log

2007-08-07 Thread Scott Marlowe
On 8/5/07, Sergei Shelukhin <[EMAIL PROTECTED]> 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 wh

[GENERAL] truncate transaction log

2007-08-07 Thread Sergei Shelukhin
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 bac