"Brendon Matthews" <brendonm@bbtechltd.com> writes:
> I have been using PostgreSQL 7.2.2 for a while now on one of our live
> machines, however all of a sudden with no warning, we are no longer able to
> run any UPDATE statements on one of our databases. SELECT and INSERT
> statements have no issues.
> The error we are getting is:
> "The backend has broken the connection. Possibly the action you have
> attempted has caused it to close."
> Immediately after this call the database system restarts itself.
Sounds like a backend crash. What do you get in the postmaster log when
this happens? If there's a core file, can you provide a gdb stack
trace? (If there's not a core file, restarting the postmaster under
"ulimit -c unlimited" should allow one to be produced.)
regards, tom lane