Re: startup script for FreeBSD

* Eduardo Kotujansky <eduardo@complex.com.br> [001123 04:25] wrote:
> Could some one send-me an example ( or tell-me where it is  in docs )
> of a shell script for start postgresql  in a FreeBSD installation
>
> Thanks
>    Eduardo

this could be more modular, and you'll want to lower the -B and -S
options unless you have a gig of RAM.

#!/bin/sh

#
#  /usr/local/etc/rc.d startup script
#
# $Wintelcom: src/paycounter_backend/dbscripts/pg.sh,v 1.4 2000/07/04 09:13:49 bright Exp $
#

DATA=/vol/amrd0/database/data
DAEMON=/usr/local/pgsql/bin/postmaster
LOGFILE=/vol/amrd0/database/data/postgres.log
PGUSER=pgsql

case `/usr/bin/whoami` in
    root)
        if [ -d /usr/local/pgsql/lib ] ; then
            /sbin/ldconfig -m /usr/local/pgsql/lib
        fi
        su -l $PGUSER -c \
            "exec $DAEMON -i -B 32768 -D$DATA -S -o "-F -S 65534" > $LOGFILE"
    ;;
    $PGUSER)
        $DAEMON -i -B 32768 -D$DATA -S -o "-F -S 65534" > $LOGFILE
    ;;
    *)
        echo you either need to be root or $PGUSER to start postgresql
        exit
    ;;
esac

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."