This looks like data corruption on that record. Or possibly on
multiple records.
I would:
a) update to the latest bug-fix release of 8.2 asap. I don't see any
fixed bugs which would cause this specific type of error but there are
a lot of them and I could have missed it.
http://www.postgresql.o
Oh, probably found the cause of the sudden restarts:
Jun 23 09:39:13 ph1phys01 genunix: [ID 603404 kern.notice] NOTICE: core_log:
postgres[25239] core dumped: /var/core/core_global.postgres
Jun 23 09:45:56 ph1phys01 genunix: [ID 603404 kern.notice] NOTICE: core_log:
postgres[26455] core dumped: /v