From owner-freebsd-ports@FreeBSD.ORG Mon Oct 29 16:11:53 2007 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 8227516A41B; Mon, 29 Oct 2007 16:11:53 +0000 (UTC) (envelope-from ler@lerctr.org) Received: from thebighonker.lerctr.org (thebighonker.lerctr.org [192.147.25.65]) by mx1.freebsd.org (Postfix) with ESMTP id 7F0CD13C4BD; Mon, 29 Oct 2007 16:11:16 +0000 (UTC) (envelope-from ler@lerctr.org) Received: from dia.lan128.lombardisoftware.com ([64.3.1.253]:33999 helo=LROSENMAN) by thebighonker.lerctr.org with esmtpa (Exim 4.68 (FreeBSD)) (envelope-from ) id 1ImUL9-000Dqq-NR; Mon, 29 Oct 2007 08:07:37 -0500 From: "Larry Rosenman" To: "'Ivan Voras'" , References: <103519023.20071027213944@gameservice.ru> In-Reply-To: Date: Mon, 29 Oct 2007 08:07:25 -0500 Message-ID: <007501c81a2c$aca002f0$05e008d0$@org> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcgY3egMeJT0fF+ARaiMCYU/aQjeYwBTpsKg Content-Language: en-us X-Spam-Score: -4.3 (----) X-LERCTR-Spam-Score: -4.3 (----) X-Spam-Report: SpamScore (-4.3/5.0) ALL_TRUSTED=-1.8, BAYES_00=-2.599, TW_PG=0.077 X-LERCTR-Spam-Report: SpamScore (-4.3/5.0) ALL_TRUSTED=-1.8, BAYES_00=-2.599, TW_PG=0.077 DomainKey-Status: no signature Cc: Subject: RE: FreeBSD Port: postgresql-server-8.2.5_2 X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 29 Oct 2007 16:11:53 -0000 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.