Re: Server stops responding in every week

In response to "Andrus" <kobruleht2@hot.ee>:

> PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 64-bit
> is installed in Windows 2008 server and servers 23 users in LAN 10 hours per
> work day.
>
> Approx once per week server stops responding: Users are waiting 4 minutes
> for query to complete but nothing happens.
>
> If postgres service is re-started in Windows Control panel, it continues
> working for a week and same issue appears again.
> Server and windows event log does not contian any information about issue.
>
>
> How to fix of diagnose it ?

SELECT * FROM pg_locks;

If there are exclusive locks being held by some process that kicks off
once a week, it could block anything else from occurring.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/