Scott Marlowe wrote:
> Did you have a long running transaction? That's usually the cause of
> this kind of thing.
Long transactions to not cause the WAL files to not be recycled. It
must be something else.
---
>
> On Sat,
Did you have a long running transaction? That's usually the cause of
this kind of thing.
On Sat, 2004-07-17 at 17:37, Hervà Piedvache wrote:
> OK it's running again many thanks ! :o)
>
> But Tom ... could you clearly explain me what is the parameter to set in the
> postgresql.conf to never have
OK it's running again many thanks ! :o)
But Tom ... could you clearly explain me what is the parameter to set in the
postgresql.conf to never have my pg_xlog partition's going full ??
I have 1.8 Gb dedicated to pg_xlog and I have set those options :
checkpoint_segments = 3 # in logfile segments
Tom,
Le samedi 17 Juillet 2004 23:06, Tom Lane a écrit :
> =?iso-8859-15?q?Herv=E9_Piedvache?= <[EMAIL PROTECTED]> writes:
> > How to solve this ??? My pg_xlog partition is full ... :o(
>
> ... so free up some space ...
But my pg_xlog partition is dedicated to the WAL files ... so I can't delete
=?iso-8859-1?q?Herv=E9_Piedvache?= <[EMAIL PROTECTED]> writes:
> Tom,
> Le samedi 17 Juillet 2004 23:06, Tom Lane a écrit :
>> =?iso-8859-15?q?Herv=E9_Piedvache?= <[EMAIL PROTECTED]> writes:
>>> How to solve this ??? My pg_xlog partition is full ... :o(
>>
>> ... so free up some space ...
> But m
=?iso-8859-15?q?Herv=E9_Piedvache?= <[EMAIL PROTECTED]> writes:
> How to solve this ??? My pg_xlog partition is full ... :o(
... so free up some space ...
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9' the
Hi,
I have my database stoping by itself during a vacuum full analyse;
Impossible to restart it ... I have this message :
Jul 17 22:03:09 stats-ugc postgres[7239]: [2-1] LOG: database system was shut
down at 2004-07-17 20:53:06 CEST
Jul 17 22:03:09 stats-ugc postgres[7239]: [3-1] LOG: checkpoi
