Re: PostgreSQL crash on Freebsd 7

Michael wrote:

> Extract from dmesg:
> pid 30622 (postgres), uid 70: exited on signal 6 (core dumped)
>
> Nothing interesting in other logs.
>
> I run FreeBSD 7.0-BETA1 on Dual-Core AMD Opteron(tm) Processor 2216
> (2394.01-MHz 686-class CPU) with ULE scheduler
> PostgreSQL 8.2.5
>
> I can't find what triggers this behavior (it started core dumping
> after upgrading from FreeBSD 6.2)

This probably means that the spinlock support is not up to speed for
your platform. It is strange though -- I think I've seen other people
using FreeBSD 7. I don't see any on the buildfarm:
http://buildfarm.postgresql.org/cgi-bin/show_status.pl

It probably means you'll need to do some hacking to make it work again.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support