Re: Old pg_xlog files
| От | Tass Chapman |
|---|---|
| Тема | Re: Old pg_xlog files |
| Дата | |
| Msg-id | ec9575e80603221347j6294cf1ge4e94147c04e3584@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Old pg_xlog files (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: Old pg_xlog files
|
| Список | pgsql-general |
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@sss.pgh.pa.us> wrote:
Vivek Khera <vivek@khera.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
В списке pgsql-general по дате отправления: