From owner-freebsd-questions@FreeBSD.ORG  Mon Apr  2 18:14:47 2007
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id D27A716A414
	for <freebsd-questions@freebsd.org>;
	Mon,  2 Apr 2007 18:14:47 +0000 (UTC)
	(envelope-from wblock@wonkity.com)
Received: from wonkity.com (wonkity.com [67.158.26.137])
	by mx1.freebsd.org (Postfix) with ESMTP id 2B1F313C483
	for <freebsd-questions@freebsd.org>;
	Mon,  2 Apr 2007 18:14:46 +0000 (UTC)
	(envelope-from wblock@wonkity.com)
Received: from wonkity.com (localhost [127.0.0.1])
	by wonkity.com (8.13.8/8.13.8) with ESMTP id l32IDnNo034653;
	Mon, 2 Apr 2007 12:13:49 -0600 (MDT)
	(envelope-from wblock@wonkity.com)
Received: from localhost (wblock@localhost)
	by wonkity.com (8.13.8/8.13.8/Submit) with ESMTP id l32IDn4K034650;
	Mon, 2 Apr 2007 12:13:49 -0600 (MDT)
	(envelope-from wblock@wonkity.com)
Date: Mon, 2 Apr 2007 12:13:49 -0600 (MDT)
From: Warren Block <wblock@wonkity.com>
To: Charles Farinella <cfarinella@appropriatesolutions.com>
In-Reply-To: <46113D03.6000604@appropriatesolutions.com>
Message-ID: <20070402120758.M34595@wonkity.com>
References: <46113D03.6000604@appropriatesolutions.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-3.0
	(wonkity.com [127.0.0.1]); Mon, 02 Apr 2007 12:13:49 -0600 (MDT)
Cc: freebsd-questions@freebsd.org
Subject: Re: automatically starting PostgreSQL
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
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: Mon, 02 Apr 2007 18:14:47 -0000

On Mon, 2 Apr 2007, Charles Farinella wrote:

> I built PostgreSQL from source

In other words, not from ports?  Or if it was from ports, which port?

> and copied the supplied startup script to 
> /etc/rc.d/postgresql.  The script works as expected.

Yes, but that's not where it should be in FreeBSD, if that's even a 
startup script meant for FreeBSD.

> In /etc/rc.conf I've added the following:
>
> postgresql_enable="YES"
>
> expecting this to automatically start PostgeSQL at boot, yet this doesn't 
> happen and there is nothing in any error log that I can find that mentions 
> any failure.

For that to work, you'd have to have the (correct) script in 
/usr/local/etc/rc.d.  Remove the source version of PostgreSQL and 
install it from the appropriate port, and the port will install the 
right script in the right place.

-Warren Block * Rapid City, South Dakota USA