Re: postgre restarts in short period

On Tue, Aug 6, 2013 at 7:56 AM, edlef <edlef(at)freemail(dot)hu> 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 paste here the logs for one day:
>
> postgresql-2013-08-05_044313.log:
> 2013-08-05 04:43:13 FATAL: the database system is starting up
> 2013-08-05 04:43:13 LOG: database system was interrupted at 2013-08-04
> 21:17:08
> 2013-08-05 04:43:13 LOG: checkpoint record is at A/C07BA3D0
> 2013-08-05 04:43:13 LOG: redo record is at A/C07BA3D0; undo record is at

SNIP

> I hope somebody has an idea how I can correct it.
> Thanks for the help!

We need to see what happens BEFORE the database was starting back up.
I.e. what caused it to shut down / restart / crash etc. The fact that
it's starting back up after a crash doesn't tell us much.