Re: Old pg_xlog files

Thanks all. It is finally begining to reuse them.

Any suggestions on what I can look at to see why the checkpoint was so far
outstanding and why it hung on in a Zombie state when we tried a soft boot?

On 3/22/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Vivek Khera <vivek(at)khera(dot)org> writes:
> > On Mar 22, 2006, at 1:37 PM, Tass Chapman wrote:
> >> 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?
>
> > no, do not delete them. they will eventually be re-used. check back
> > in a few days and see how old the various files are...
>
> If there are more than about 2*checkpoint_segments of them, the extras
> will be removed by the next successful checkpoint. So there's really no
> reason to touch them manually.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>