diff options
Diffstat (limited to 'databases/postgresql80-server/files/pgsql.sh')
| -rw-r--r-- | databases/postgresql80-server/files/pgsql.sh | 142 |
1 files changed, 142 insertions, 0 deletions
diff --git a/databases/postgresql80-server/files/pgsql.sh b/databases/postgresql80-server/files/pgsql.sh new file mode 100644 index 00000000000..481fc1e9d14 --- /dev/null +++ b/databases/postgresql80-server/files/pgsql.sh @@ -0,0 +1,142 @@ +#!@RCD_SCRIPTS_SHELL@ +# +# $NetBSD: pgsql.sh,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $ +# +# PostgreSQL database rc.d control script +# +# PROVIDE: pgsql +# REQUIRE: DAEMON +# KEYWORD: shutdown +# +# You will need to set some variables in /etc/rc.conf to start PostgreSQL: +# +# pgsql=YES +# +# The following variables are optional: +# +# pgsql_flags="-i" # allows TCP/IP connections +# pgsql_flags="-i -l" # enables SSL connections +# pgsql_home="/path/to/home" # path to pgsql database directory +# +# "pgsql_flags" contains options for the PostgreSQL postmaster. See +# postmaster(1) for possible options. + +if [ -f /etc/rc.subr ]; then + . /etc/rc.subr +fi + +name="pgsql" +rcvar=$name +pgsql_user="@PGUSER@" +pgsql_group="@PGGROUP@" +eval pgsql_home="~$pgsql_user" + +command="@PREFIX@/bin/postmaster" +ctl_command="@PREFIX@/bin/pg_ctl" +extra_commands="initdb" + +if [ -f /etc/rc.subr -a -d /etc/rc.d -a -f /etc/rc.d/DAEMON ]; then + load_rc_config $name +elif [ -f /etc/rc.conf ]; then + . /etc/rc.conf +fi + +pidfile="${pgsql_home}/data/postmaster.pid" +common_args="-D ${pgsql_home}/data" +start_command_args="-w -s -l ${pgsql_home}/errlog" +stop_command_args="-s -m fast" + +initdb_cmd="pgsql_initdb" +start_precmd="pgsql_precmd" +start_cmd="pgsql_doit start" +restart_cmd="pgsql_doit restart" +stop_cmd="pgsql_doit stop" + +ulimit -n 4096 + +pgsql_precmd() +{ + if [ ! -d ${pgsql_home}/data/base ]; then + pgsql_initdb + fi +} + +pgsql_initdb() +{ + initdb="@PREFIX@/bin/initdb" + + if [ ! -x ${initdb} ]; then + return 1 + fi + if [ -d ${pgsql_home}/data/base ]; then + @ECHO@ "The PostgreSQL template databases have already been initialized." + @ECHO@ "Skipping database initialization." + else + @ECHO@ "Initializing PostgreSQL databases." + @MKDIR@ -p ${pgsql_home} + @CHOWN@ ${pgsql_user} ${pgsql_home} + @CHGRP@ ${pgsql_group} ${pgsql_home} + @CHMOD@ 0750 ${pgsql_home} + eval doit_command=\"${initdb} ${common_args} ${flags}\" + doit="@SU@ -m ${pgsql_user} -c '${doit_command}'" + eval $doit + fi +} + +pgsql_doit() +{ + action=$1 + + case ${action} in + start|restart) + if [ -n "${pgsql_flags}" ]; then + start_command_args="${start_command_args} -o \\\"${pgsql_flags}\\\"" + fi + command_args="${common_args} ${start_command_args} ${command_args}" + ;; + stop) + command_args="${common_args} ${stop_command_args} ${command_args}" + ;; + *) + command_args="${common_args} ${command_args}" + ;; + esac + + if [ ! -x ${ctl_command} ]; then + return + fi + + case ${action} in + start) @ECHO@ "Starting ${name}." ;; + stop) @ECHO@ "Stopping ${name}." ;; + restart) @ECHO@ "Restarting ${name}." ;; + esac + + eval doit_command=\"${ctl_command} ${action} ${command_args}\" + doit="@SU@ -m ${pgsql_user} -c '${doit_command}'" + eval $doit +} + +if [ -f /etc/rc.subr -a -d /etc/rc.d -a -f /etc/rc.d/DAEMON ]; then + load_rc_config $name + run_rc_command "$1" +else + if [ -f /etc/rc.conf ]; then + . /etc/rc.conf + fi + case "$1" in + initdb) + eval ${initdb_cmd} + ;; + restart) + eval ${restart_cmd} + ;; + stop) + eval ${stop_cmd} + ;; + *) + eval ${start_precmd} + eval ${start_cmd} + ;; + esac +fi |