From owner-freebsd-questions@FreeBSD.ORG  Sun Feb  6 22:25:23 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id D0EF816A4D2
	for <freebsd-questions@freebsd.org>;
	Sun,  6 Feb 2005 22:25:23 +0000 (GMT)
Received: from 9.hellooperator.net (cpc3-cdif2-3-0-cust202.cdif.cable.ntl.com
	[81.103.32.202])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 57CA143D1D
	for <freebsd-questions@freebsd.org>;
	Sun,  6 Feb 2005 22:25:23 +0000 (GMT)
	(envelope-from rasputnik@hellooperator.net)
Received: from [10.4.0.5] (helo=eris.tenfour)
	by 9.hellooperator.net with esmtp (Exim 4.43)
	id 1CxuqG-0006ZB-PV
	for freebsd-questions@freebsd.org; Sun, 06 Feb 2005 22:25:22 +0000
Received: from rasputnik by eris.tenfour with local (Exim 4.44 (FreeBSD))
	id 1CxuqG-000EO2-Jw
	for freebsd-questions@freebsd.org; Sun, 06 Feb 2005 22:25:20 +0000
Date: Sun, 6 Feb 2005 22:25:20 +0000
From: Dick Davies <rasputnik@hellooperator.net>
To: FreeBSD Questions <freebsd-questions@freebsd.org>
Message-ID: <20050206222520.GC473@eris.tenfour>
References: <20050206213730.GB473@eris.tenfour>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20050206213730.GB473@eris.tenfour>
User-Agent: Mutt/1.4.2.1i
Subject: Re: postgres 8 init script problem?
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: Dick Davies <rasputnik@hellooperator.net>
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 06 Feb 2005 22:25:23 -0000

* Dick Davies <rasputnik@hellooperator.net> [0237 21:37]:
> Anyone else having problems starting postgres 8.0.1 (from ports)
> on RELENG_5?
> 
> It seems to start alright, but clankily:
> 
> root$ /usr/local/etc/rc.d/010.pgsql.sh start
> <hang for about a minute>
> could not start postmaster
> root$ /usr/local/etc/rc.d/010.pgsql.sh status
> pg_ctl: postmaster is running (PID: 54846)
> /usr/local/bin/postgres -D /usr/local/pgsql/data

Ah, found it. I had PGHOST set in roots environment
(after 'su'ing rather than 'su -'ing).

unset PG_HOST

gets it running in no time.

(Looks like a bug in 010.pgsql.sh, though. roots environment 
shouldn't get picked up, surely?)

-- 
'A little rudeness and disrespect can elevate a meaningless interaction
into a battle of wills and add drama to an otherwise dull day.'
		-- Calvin discovers Usenet
Rasputin :: Jack of All Trades - Master of Nuns