X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 927579FB1B7 for ; Tue, 25 Jul 2006 11:54:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 51703-02-5 for ; Tue, 25 Jul 2006 11:53:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 199E59FB5C6 for ; Tue, 25 Jul 2006 11:26:19 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mx3.mail.bg (mx-balancer.mail.bg [193.201.172.113]) by svr4.postgresql.org (Postfix) with ESMTP id 895E25AF039 for ; Tue, 25 Jul 2006 13:56:19 +0000 (GMT) Received: from localhost (web13.mail.bg [193.201.172.110]) by mx3.mail.bg (Postfix) with ESMTP id E8E3DE09CA8 for ; Tue, 25 Jul 2006 16:56:17 +0300 (EEST) Received: from unisoft.unisoftbg.com (unisoft.unisoftbg.com [194.12.229.193]) by mail.bg (mail.bG Webmail 4.0.1) with HTTP for ; Tue, 25 Jul 2006 16:56:46 +0300 Message-ID: <1153835806.4be9ee1569974@mail.bg> Date: Tue, 25 Jul 2006 16:56:46 +0300 From: zz_11@mail.bg To: pgsql-admin@postgresql.org Subject: startup script for FreeBSD 6.1 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1251" Content-Disposition: inline Content-Transfer-Encoding: quoted-printable User-Agent: mail.bG Webmail 4.0-cvs X-Originating-IP: 194.12.229.193 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.667 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, NO_REAL_NAME, SPF_FAIL X-Spam-Level: * X-Archive-Number: 200607/203 X-Sequence-Number: 22449 Hi, I know it is stupied, but I can not resolve my problem. I am using postgresql on many servers ( > 200). I install it on FreeBSD and till version 6.1 it worked perfect. I do not use ports from FreeBSD. I install it from sources. Also 3 y. ago I got from postgres web site a startup script for FreeBSD and it worked well. But after installing FreeBSD on my next DB server I make a copy of my startup script to /usr/local/etc/rc.d and after system restart pg do not started alone. If I login as root and execute /usr/local/etc/rc.d/postgres.sh start, all is ok. I can not find the reason for this mistake. My questions : - Exists some one using postgresql and FreeBSD 6.1 ? If yes pls. send me your startup script. - Point me to any direction to find the problem ( my pg version is 8.1.4). I wrote to FreeBSD mailing list without any reaction till now. Many thanks, Ivan. Also this is my startup script: # ls -l /usr/local/etc/rc.d/postgres.sh -rwxr-xr-x 1 root wheel 1327 Jul 24 21:25 /usr/local/etc/rc.d/postgres.sh #! /bin/sh # PostgreSQL boot time startup script for FreeBSD. Copy this file to # /usr/local/etc/rc.d/postgresql. # Created through merger of the Linux start script by Ryan Kirkpatrick # and the script in the FreeBSD ports collection. # $Header: /cvsroot/pgsql-server/contrib/start-scripts/freebsd,v 1.2 2001/04/19 19:17:44 petere Exp $ ## EDIT FROM HERE # PROVIDE: postgresql # Installation prefix prefix=3D/usr # Data directory PGDATA=3D"/usr/mydb" # Who to run pg_ctl as, should be "postgres". PGUSER=3Dpostgres # Where to keep a log file PGLOG=3D"$PGDATA/postgres.log" ## STOP EDITING HERE # The path that is to be used for the script PATH=3D/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin # What to use to start up the postmaster DAEMON=3D"$prefix/bin/pg_ctl" test -x "$DAEMON" || exit 0 case $1 in start) su -l $PGUSER -c "$DAEMON start -D '$PGDATA' -s -l $PGLOG" echo -n ' postgresql' ;; stop) su -l $PGUSER -c "$DAEMON stop -D '$PGDATA' -s -m fast" ;; restart) su -l $PGUSER -c "$DAEMON restart -D '$PGDATA' -s -m fast" ;; status) su -l $PGUSER -c "$DAEMON status -D '$PGDATA'" ;; *) # Print help echo "Usage: Basename $0 {start|stop|restart|status}" 1>&2 exit 1 ;; esac exit 0 ----------------------------- =C2=D1=C5=CA=C8 =C4=C5=CD =ED=E0=E9-=ED=EE=E2=EE=F2=EE =E7=E0 =F6=E8=F4=F0= =EE=E2=E8=F2=E5 =F2=E5=F5=ED=EE=EB=EE=E3=E8=E8 http://www.digital.bg