The version of Postgres is 7.4.When I said the process had terminated abnormally - what I meant was a UNIX process (C program) had opened a database connection, run some updates without a COMMIT and then exited without closing the connection to the database or committing the transactions.