Date: Mon, 29 Oct 2007 08:07:25 -0500 From: "Larry Rosenman" <ler@lerctr.org> To: "'Ivan Voras'" <ivoras@freebsd.org>, <freebsd-ports@freebsd.org> Subject: RE: FreeBSD Port: postgresql-server-8.2.5_2 Message-ID: <007501c81a2c$aca002f0$05e008d0$@org> In-Reply-To: <fg05f7$n32$1@ger.gmane.org> References: <103519023.20071027213944@gameservice.ru> <fg05f7$n32$1@ger.gmane.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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=3D# select version();
version =
=20
-------------------------------------------------------------------------=
------- =
------------------
PostgreSQL 8.2.5 on amd64-portbld-freebsd7.0, compiled by GCC cc (GCC) =
4.2.1 20 070719 =
[FreeBSD]
(1 row)
ler=3D# 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=3D#
--=20
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
-----Original Message-----
From: owner-freebsd-ports@freebsd.org =
[mailto:owner-freebsd-ports@freebsd.org] 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.
>=20
> PostgreSQL 8.2.5 compiled from ports core dumps on freebsd 7=20
> (RELENG_7), i've asked pgsql-bugs about this issue, and they answered, =
> that probably FreeBSD 7 have problems with spinlocks:
>=20
> 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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?007501c81a2c$aca002f0$05e008d0$>