From owner-freebsd-questions@FreeBSD.ORG  Mon Sep  1 09:21:32 2003
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 D9F7C16A4BF
	for <freebsd-questions@freebsd.org>;
	Mon,  1 Sep 2003 09:21:32 -0700 (PDT)
Received: from sferics.mongueurs.net (sferics.mongueurs.net [81.80.147.197])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 0AC5044008
	for <freebsd-questions@freebsd.org>;
	Mon,  1 Sep 2003 09:21:32 -0700 (PDT)
	(envelope-from david@landgren.net)
Received: from landgren.net (81-80-147-206.bpinet.com [81.80.147.206])
	by sferics.mongueurs.net (Postfix) with ESMTP id 6B1A5A99B
	for <freebsd-questions@freebsd.org>;
	Mon,  1 Sep 2003 18:21:30 +0200 (CEST)
Message-ID: <3F53710B.7060004@landgren.net>
Date: Mon, 01 Sep 2003 18:17:15 +0200
From: David Landgren <david@landgren.net>
Organization: A thousand golden eyes are watching
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.5a) Gecko/20030718
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: freebsd-questions@freebsd.org
References: <000001c3709f$8f45e7a0$0400a8c0@fire>
In-Reply-To: <000001c3709f$8f45e7a0$0400a8c0@fire>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: How to run PostgreSQL on boot?
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
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, 01 Sep 2003 16:21:33 -0000

Alex Zivenko wrote:
> Hi all!
> I need to run Postgresql server on startup. It means, that I need to start postmaster every boot. How can I do this?
> Sorry for my english.

I have the following file on the servers that run Postgresql, named 
/usr/local/etc/rc.d/postgresql.sh:

#! /bin/sh

su postgres -c '/home/pgsql/bin/pg_ctl start \
   -D /home/pgsql/data -l /var/log/postgresql'

You will probably have to change paths etc. to suit your site, but 
this is the general idea.

David