Re: postgre restarts in short period

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

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
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2013-08-06 14:34:27 Re: postgre restarts in short period
Previous Message Tom Lane 2013-08-06 14:23:35 Re: [GENERAL] Possible bug with row_to_json