FreeBSD Port: postgresql-server-8.2.5_2

[Larry Rosenman]

I have 8.2.5 running on a 7/amd64 box without issue...

$ psql
Welcome to psql 8.2.5, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

ler=# select version();
                                             version                                                                                     
--------------------------------------------------------------------------------                                                         ------------------
 PostgreSQL 8.2.5 on amd64-portbld-freebsd7.0, compiled by GCC cc (GCC) 4.2.1 20                                                         070719  [FreeBSD]
(1 row)

ler=# select version();
                                             version
--------------------------------------------------------------------------------------------------
 PostgreSQL 8.2.5 on amd64-portbld-freebsd7.0, compiled by GCC cc (GCC) 4.2.1 20070719  [FreeBSD]
(1 row)

ler=#


-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 512-248-2683                E-Mail: ler at lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

-----Original Message-----
From: owner-freebsd-ports at freebsd.org [mailto:owner-freebsd-ports at freebsd.org] On Behalf Of Ivan Voras
Sent: Saturday, October 27, 2007 3:02 PM
To: freebsd-ports at freebsd.org
Subject: Re: FreeBSD Port: postgresql-server-8.2.5_2

Michael wrote:
> Hello.
> 
> PostgreSQL 8.2.5 compiled from ports core dumps on freebsd 7 
> (RELENG_7), i've asked pgsql-bugs about this issue, and they answered, 
> that probably FreeBSD 7 have problems with spinlocks:
> 
> http://archives.postgresql.org/pgsql-bugs/2007-10/msg00197.php

Postmaster isn't threaded so it looks like a problem with their own implementation of spinlock, not the OS's.

One thing that may or may not help you is: can you rebuild your (exact!) version of PostgreSQL on a 6.2 machine, save the output (e.g. with tee), then rebuild it (the *same* version) on 7.0 and also save the output, then compare them?

> Can you help me resolve this problem?

Did you look at the postmaster's stderror output?

For what is worth, PostgreSQL 8.1 works on 7 flawlessly.