Postgresql 8.3 on OSX hangs

From: Kevin Kempter <cs_dba(at)consistentstate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgresql 8.3 on OSX hangs
Date: 2010-08-24 16:08:00
Message-ID: 201008241008.00551.cs_dba@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Browse pgsql-admin by date

  From Date Subject
Next Message Ullah, Syed 2010-08-24 16:19:11 Problem with \set command
Previous Message Kevin Grittner 2010-08-24 13:54:49 Re: replication solution