Vivek Khera <vivek@xxxxxxxxx> 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
