From owner-freebsd-questions@FreeBSD.ORG  Sat Nov  6 00:43:07 2004
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 32CFA16A4D7
	for <freebsd-questions@freebsd.org>;
	Sat,  6 Nov 2004 00:43:07 +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 D57EB43D1D
	for <freebsd-questions@freebsd.org>;
	Sat,  6 Nov 2004 00:43:06 +0000 (GMT)
	(envelope-from rasputin@hellooperator.net)
Received: from rasputin by 9.hellooperator.net with local (Exim 4.43)
	id 1CQEfZ-0004Y6-Gs; Sat, 06 Nov 2004 00:43:05 +0000
Date: Sat, 6 Nov 2004 00:43:05 +0000
From: Dick Davies <rasputnik@hellooperator.net>
To: v.demartino2@virgilio.it
Message-ID: <20041106004305.GB1091@lb.tenfour>
References: <41536B850007F193@ims3e.cp.tin.it>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <41536B850007F193@ims3e.cp.tin.it>
User-Agent: Mutt/1.4.2.1i
Sender: Rasputin <rasputin@hellooperator.net>
cc: FreeBSD Questions <freebsd-questions@freebsd.org>
Subject: Re: Postgresql not starting...
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: Sat, 06 Nov 2004 00:43:07 -0000

* v.demartino2@virgilio.it <v.demartino2@virgilio.it> [1153 22:53]:

> In /usr/local/etc/rc.d I find 010.pgsql.sh to start the service but
> "/usr/local/etc/rc.d/010.pgsql.sh start"
> doesn't look to do anything.
> 
> if I "su - pgsql" then try to "createdb" an error of missing server pops
> up.
> Could you please help in a straightforward way how to set postgresql straight?

less ~pgsql/post-install-notes 

you want 

 su -l pgsql -c initdb

initdb creates the postgres system catalogs etc, you can't use createdb without
them (since createdb makes databases by copying the template1  database).

> By the way how can I tell FreeBSD I want the postgresql to be started at
> boot time?

'/usr/local/etc/rc.d/010.pgsql.sh start'  should work after you've run that.

Once the postmaster starts, then createdb will work.

-- 
Aww, you know what always cheers me up? Laughing at other people's misfortunes. - Bender
Rasputin :: Jack of All Trades - Master of Nuns