Re: logfiles filling up

Поиск
Список
Период
Сортировка
От Erik Myllymaki
Тема Re: logfiles filling up
Дата
Msg-id 4458B4B6.10803@aviawest.com
обсуждение исходный текст
Ответ на Re: logfiles filling up  ("Magnus Hagander" <mha@sollentuna.net>)
Список pgsql-general
yes I do.


Magnus Hagander wrote:
> Do you actively use SSL on this server?
>
> //Magnus
>
>> -----Original Message-----
>> From: pgsql-general-owner@postgresql.org
>> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Erik
>> Myllymaki
>> Sent: Wednesday, May 03, 2006 3:36 PM
>> To: pgsql-general@postgresql.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
>>

В списке pgsql-general по дате отправления:

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: logfiles filling up
Следующее
От: "Javier de la Torre"
Дата:
Сообщение: psql is slow and it does not take much resources