From: | Erik Myllymaki <erik(dot)myllymaki(at)aviawest(dot)com> |
---|---|
To: | Magnus Hagander <mha(at)sollentuna(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: logfiles filling up |
Date: | 2006-05-03 13:48:38 |
Message-ID: | 4458B4B6.10803@aviawest.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
yes I do.
Magnus Hagander wrote:
> Do you actively use SSL on this server?
>
> //Magnus
>
>> -----Original Message-----
>> From: pgsql-general-owner(at)postgresql(dot)org
>> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Erik
>> Myllymaki
>> Sent: Wednesday, May 03, 2006 3:36 PM
>> To: pgsql-general(at)postgresql(dot)org
>> Subject: Re: [GENERAL] logfiles filling up
>>
>> I will add to my initial post:
>>
>> This is a fresh install with a small database (30MB over 12
>> tables), no other applications on this server and only one
>> user - it's a development machine.
>>
>> And when I say the logfiles "fill up" I mean the entire
>> partition fills, rapidly, until there is "no room left on device".
>>
>> The last time this happened it took less than 10 minutes for
>> 7GB to fill.
>>
>> Seems to happen every couple of days.
>>
>> Shutting down Postgres and removing the logfiles, and then
>> restarting Postgres fixes things temporarily.
>>
>> Erik Myllymaki wrote:
>>> I'm running Postgresql 8.1.3 on Windows 2003.
>>>
>>> logfiles fill with the following line:
>>>
>>> "SSL SYSCALL error: A blocking operation was interrupted by
>> a call to
>>> WSACancelBlockingCall."
>>>
>>> Any ideas?
>>>
>>> Thanks.
>>>
>>>
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 9: In versions below 8.0, the planner will ignore your desire to
>>> choose an index scan if your joining column's datatypes do not
>>> match
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 3: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faq
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Javier de la Torre | 2006-05-03 14:00:12 | psql is slow and it does not take much resources |
Previous Message | Magnus Hagander | 2006-05-03 13:45:04 | Re: logfiles filling up |