Postgresql 8.3 on OSX hangs

Hi all;

we have a client experiencing the following scenario:


- Postgresql 8.3.10 plus postgis 1.5.1

- Both databases stop responding to queries and several of the backend
processes show as being in an uninterruptible state (state "Us" according to
a ps aux)

- The client killed the processes, did a pg_dumpall and a restore only to find
the condition happen again the next day

- The client read every file reported by lsof as being accessed by a backend
process without issues.. thus it seems to NOT be a disk I/O issue.



Thoughts?



--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Kevin Kempter [ Di, 24 August 2010 18:08 ] [ ID #2046552 ]
Datenbanken » gmane.comp.db.postgresql.admin » Postgresql 8.3 on OSX hangs

Vorheriges Thema: replication solution
Nächstes Thema: Enterprise pg database monitoring