On Aug 7, 9:57 pm, si...@xxxxxxxxxxxxxxx ("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 dozens gigabytes of
> > spaces.
> > Is there any way to remove it while keeping the database operational/
> > restore-able by copying it back?
>
> Reduce the setting of checkpoint_segments to something more realistic.
>
Hmm. Reduced to 60, during the db conversion from MySQL Postgres used
to complain about this setting so I increased it to the sky. Thanks :)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
