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.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
