Old pg_xlog files - Mailing list pgsql-general

From Tass Chapman
Subject Old pg_xlog files
Date
Msg-id ec9575e80603221037j192696f1y7cad85404bc42568@mail.gmail.com
Whole thread Raw
Responses Re: Old pg_xlog files  (Vivek Khera <vivek@khera.org>)
List pgsql-general
I am running postgres 7.4.9 on an LFS system , and had a long outstanding pg_checkpoint that seemed to prevent the DB from being cleanly shutdown.
The box was power cycled (not my choice...) and when it came up Postgres did it's recovery and seemed to be fine.
 
Checkpoints appear to be up to date (via pg_controldata), but the pg_xlog directory has 95 files, of which 90 are dated before midnight yesterday or earlier.
 
Can I just delete them safely? Or is there some recovery method I can do?
 
Thanks.
 
 

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Advantages of PostgreSQL over MySQL 5.0
Next
From: Vivek Khera
Date:
Subject: Re: Old pg_xlog files