Thread: Keeping postmaster running or restarting

I've been using PostgreSQL since it was Postgres95 and this has always been
a problem- only recently it has become a BIG problem.

I'm running an e-commerce backend using PostgreSQL and it works great but
crashes every once in a while for mysterious reasons and then the whole
company is breathing down my neck about it since we can't accept orders
without a database.

The only hint I've found is this in the log file:

  ERROR:  postmaster: StreamConnection: accept: Network is unreachable

This is PostgreSQL 6.5.2 compiled from source on a RedHat Linux 5.2 (Intel)
system.

If I can't control this, how can I detect crashes like this and restart
the postmaster quickly?

-+Fozz

--
Doran L. Barton <fozz@iodynamics.com>
Iodynamics LLC -- "Internetworking the masses"
<URL:http://www.iodynamics.com/>