| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Vivek Khera <vivek(at)khera(dot)org> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Old pg_xlog files |
| Date: | 2006-03-22 19:14:36 |
| Message-ID: | 18637.1143054876@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Caduto | 2006-03-22 19:31:11 | question about the admin contrib module and binary RPMs |
| Previous Message | Jeffrey Melloy | 2006-03-22 19:08:48 | Re: Advantages of PostgreSQL over MySQL 5.0 |