"Josh Berkus" <josh@agliodbs.com> writes:
> When I got to the machine in the morning, there were 3 processes, one
> query, one checkpoint process and the postmaster which were frozen.
> SIGHUP and SIGTERM were ignored by these; SIGKILL was able to kill
> the postmaster process, but the two other processes went to "D" status
> and were untouchable.
You've got hardware problems. It's not Postgres' fault if the disk
stops responding, which is what a process stuck in disk-wait state
implies.
regards, tom lane