Re: Growing pg_xlog - Mailing list pgsql-admin

From E. Lefty Kreouzis
Subject Re: Growing pg_xlog
Date
Msg-id 3F13B03C.6020207@internet.gr
Whole thread Raw
In response to Re: Growing pg_xlog  (Florian Weimer <fw@deneb.enyo.de>)
List pgsql-admin
Florian Weimer wrote:

>On Mon, Jul 14, 2003 at 12:55:19PM -0400, Tom Lane wrote:
>
>
>
>>Florian Weimer <fw@deneb.enyo.de> writes:
>>
>>
>>>I seem to have some obscure problem with the WAL logs (AFAIK that's what
>>>is stored in the pg_xlog directory):
>>>
>>>
>>>63G     /var/lib/postgres/data/pg_xlog
>>>
>>>
>>>This is a bit too much wasted space for my taste. 8-/
>>>
>>>
>>The only theory that comes to mind is that the automatically issued
>>checkpoint operations are failing before they get to the stage of
>>truncating the WAL.  Is there anything suspicious looking in the
>>postmaster log?
>>
>>
>
>No, I'm afraid.  However, the checkpoint subprocess was stuck in the "T"
>state (meaning that it had received SIGSTOP). 8-/
>
>
>

Ah, running on linux 2.4 I suppose. There is a known bug if someone
'strace's a process and the kills the strace process the traced process
is stuck in the  T state and needs kill -SIGCONT to continue

Lefty


pgsql-admin by date:

Previous
From: Will LaShell
Date:
Subject: Re: corrupt data - caused by lm-sensors?
Next
From: "Nigel Bishop"
Date:
Subject: Installing plpgsql gives error