Re: postgre restarts in short period

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!

Best guess there is an external program causing problems. The timestamps
are interesting and somewhat regular:

database system was interrupted at 2013-08-04 21:17:08
~7 hrs
database system was interrupted at 2013-08-05 04:43:14
4 hrs
database system was interrupted at 2013-08-05 08:43:19
~7 hrs
database system was interrupted at 2013-08-05 15:49:18

Given that this is Windows have you investigated the possibility of
interference from Anti-virus software.

>
> fenor
>
>
>

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