From owner-freebsd-ports Sat Oct 4 12:02:32 1997 Return-Path: Received: (from root@localhost) by hub.freebsd.org (8.8.7/8.8.7) id MAA01406 for ports-outgoing; Sat, 4 Oct 1997 12:02:32 -0700 (PDT) Received: from news1.gtn.com (news1.gtn.com [194.77.0.15]) by hub.freebsd.org (8.8.7/8.8.7) with ESMTP id MAA01356; Sat, 4 Oct 1997 12:00:47 -0700 (PDT) Received: (from uucp@localhost) by news1.gtn.com (8.8.6/8.8.6) with UUCP id TAA17527; Sat, 4 Oct 1997 19:45:14 +0100 (MET) Received: (from andreas@localhost) by klemm.gtn.com (8.8.7/8.8.7) id UAA14420; Sat, 4 Oct 1997 20:41:47 +0200 (CEST) (envelope-from andreas) Message-ID: <19971004204147.27006@klemm.gtn.com> Date: Sat, 4 Oct 1997 20:41:47 +0200 From: Andreas Klemm To: John Fieber Cc: scrappy@FreeBSD.ORG, ports@FreeBSD.ORG Subject: Re: Postgresql 6.2 References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.84 In-Reply-To: ; from John Fieber on Sat, Oct 04, 1997 at 01:07:52PM -0500 X-Disclaimer: A free society is one where it is safe to be unpopular X-Operating-System: FreeBSD 3.0-CURRENT SMP Sender: owner-freebsd-ports@FreeBSD.ORG X-Loop: FreeBSD.org Precedence: bulk On Sat, Oct 04, 1997 at 01:07:52PM -0500, John Fieber wrote: > Two problems with the the postgresql 6.2 port on FreeBSD 2.2.2 > (with a slightly newer kernel) > > 1) The rc.d script doesn't work...the -D argument is ignored. > Try changing the data location, it has no effect. If I echo a > commend line to su, it works fine: > > if [ -x /usr/local/pgsql/bin/postmaster ]; then > echo -n ' pgsql' > echo '/usr/local/pgsql/bin/postmaster -S -D/home/pgsql/data -o -F' | su pgsql > fi Same effect here on -current. I had to add backslashes to the startup script, did you try to use the latest update of the rc script in the filesdir ? > 2) When loading my dumped data, my system crashes reliably. > The only evidence I have at the moment is: BTW, which pg_dumpall script did you use, the one from 6.1 or 6.2 ? > Oct 4 11:16:44 fallout /kernel: swap_pager: indefinite wait > buffer: device: 132105, blkno: 12568, size: 20480 > > I'm sorry I personally don't have time to invesgigate this (I'm > just going back t 6.1) but thought you might like to know. > I can, however, make the offending data available (about 47MB > uncompressed). I'm not so deep in this postgresql business. Only did the port.. - don't use it myself exessively - have no FreeBSD-2.2 system Don't know how I should debug this here. Maybe you could please assist me and make a problem report directed to the Postgresql developement team ? If this problem should be known with 2.2 and there is no fix currently, then we had to backout 6.2 and restore 6.1.1. But I don't believe this ... Cc'd to scrappy, maybe he is able to help. He wrote me in a personal e-mail, that 6.2 is a real improvement over 6.1, so maybe he knows more about this and can help ... Andreas /// -- Andreas Klemm powered by ,,symmetric multiprocessor FreeBSD'' andreas@klemm.gtn.com - http://www.freebsd.org/~fsmp/SMP/SMP.html andreas@FreeBSD.ORG - http://www.freebsd.org/~fsmp/SMP/benches.html