Postgres Pro
Downloads
Home   >   mailing lists

truncate transaction log - Mailing list pgsql-general

From Sergei Shelukhin
Subject truncate transaction log
Date
Msg-id 1186310715.175130.196870@g4g2000hsf.googlegroups.com
Whole thread Raw
Responses Re: truncate transaction log  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: truncate transaction log  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: "Gregory Williamson"
Date:
Subject: Re: List tables in reverse dependancy order
Next
From: Ranieri Mazili
Date:
Subject: Using function like where clause