Re: Server stops responding in every week

On Friday 21 January 2011 7:13:23 am Andy Colson wrote:
> On 1/21/2011 7:16 AM, Andrus wrote:
> > 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 ?
> > Should I move to 32 Postgres 9.0 server or other idea ?
> >
> > Andrus.
>
> Does PG start swapping to disk?
> Does ram using increase over the week?
> Have you looked at pg_stat_activity and pg_locks?
> Do you see "Idle in transaction" (probably in task manager)?
>
> -Andy

To add to this.
Is there a backup being done? Maybe not pg_dump but some Windows backup program?

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