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: [EMAIL PROTECTED]
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ivan Voras
Sent: Saturday, October 27, 2007 3:02 PM
To: freebsd-ports@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.


_______________________________________________
freebsd-ports@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to