I tried a clean rebuild as Tom Lane suggested, but this didn't help.
Anyone offers commercial support for solving this problem?
M> Hello.
M> I have problems with Postgres core dumping on FreeBSD7 (RELENG_7)
M> Here is backtrace from gdb postgres postgres.core:
M> (gdb) bt
M> #0 0x485dc277 in kill () from /lib/libc.so.7
M> #1 0x485dc1d6 in raise () from /lib/libc.so.7
M> #2 0x485dadda in abort () from /lib/libc.so.7
M> #3 0x0824c075 in errfinish ()
M> #4 0x0824c8b1 in elog_finish ()
M> #5 0x081c9184 in s_lock ()
M> #6 0x081c8d48 in LWLockAcquire ()
M> #7 0x081c61ec in LockAcquire ()
M> #8 0x081c4289 in LockRelationOid ()
M> #9 0x080938fc in relation_open ()
M> #10 0x08096d5a in index_open ()
M> #11 0x08096139 in systable_beginscan ()
M> #12 0x08134f10 in RelationBuildTriggers ()
M> #13 0x08245d4d in RelationCacheInitializePhase2 ()
M> #14 0x08256af0 in InitPostgres ()
M> #15 0x081cfd13 in PostgresMain ()
M> #16 0x081a90ec in ClosePostmasterPorts ()
M> #17 0x081a9ea7 in PostmasterMain ()
M> #18 0x0816912f in main ()
M> Extract from dmesg:
M> pid 30622 (postgres), uid 70: exited on signal 6 (core dumped)
M> Nothing interesting in other logs.
M> I run FreeBSD 7.0-BETA1 on Dual-Core AMD Opteron(tm) Processor 2216
M> (2394.01-MHz 686-class CPU) with ULE scheduler
M> PostgreSQL 8.2.5
M> I can't find what triggers this behavior (it started core dumping
M> after upgrading from FreeBSD 6.2)
M> Anyone have solution for this problem?
M> Michael
M> ---------------------------(end of
M> broadcast)---------------------------
M> TIP 7: You can help support the PostgreSQL project by donating at
M> http://www.postgresql.org/about/donate
Michael