Re: postgre restarts in short period

From: edlef <edlef(at)freemail(dot)hu>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgre restarts in short period
Date: 2013-08-06 14:45:24
Message-ID: 52010C04.9030508@freemail.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I looked into other log files, but there is no regularity. I found
intervals when it restarted 2-3 time in a hour.
What I pasted was a full days log entrys, they were not snipets. There
are no entries about the shot down.
I try to find when it all began.

fenor

2013.08.06. 16:32 keltezéssel, Adrian Klaver írta:
> On 08/06/2013 06:56 AM, edlef wrote:
>> Hi,
>>
>> Our client has began to complain for a few days that the application can
>> not connect to the database more times.
>> I looked into the logs and as far as I can see, postgresql restarts more
>> times a day. I made a vacuum (full, freeze, analyze) on the database and
>> reindexed everything, but it looks, nothing has changed.
>>
>> Server data:
>> Windows Standard Server 2007 SP2 64 bit
>> Intel Xeon 3GHz
>> 4MB ram
>>
>> Postgresql 8.2 32 bit
>>
>> The application is writen in php.
>>
>>
>
>>
>> I hope somebody has an idea how I can correct it.
>> Thanks for the help!
>
> In addition to my previous comments, it would be nice to see the tail
> end of the logs previous to the ones shown. In other words those logs
> that show the database shutting down or at least what was happening
> just before it shut down.
>
>>
>> fenor
>>
>>
>>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2013-08-06 14:53:01 Re: postgre restarts in short period
Previous Message Scott Marlowe 2013-08-06 14:34:27 Re: postgre restarts in short period