#!/bin/sh # $FreeBSD$ # # PROVIDE: postgresql # REQUIRE: LOGIN # KEYWORD: shutdown # # Add the following line to /etc/rc.conf to enable PostgreSQL: # # postgresql_enable="YES" # # optional # postgresql_data="%%PREFIX%%/%%PG_USER%%/data" # postgresql_flags="-w -s -m fast" # postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C" # postgresql_class="default" # postgresql_profiles="" # # See %%PREFIX%%/share/doc/postgresql/README-server for more info # # This scripts takes one of the following commands: # # start stop restart reload status initdb # # For postmaster startup options, edit ${postgresql_data}/postgresql.conf command=%%PREFIX%%/bin/pg_ctl . /etc/rc.subr load_rc_config postgresql # set defaults postgresql_enable=${postgresql_enable:-"NO"} postgresql_flags=${postgresql_flags:-"-w -s -m fast"} postgresql_user=${postgresql_user:-"%%PG_USER%%"} eval postgresql_data=${postgresql_data:-"~${postgresql_user}/data"} postgresql_class=${postgresql_class:-"default"} postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"} name=postgresql rcvar=postgresql_enable extra_commands="reload initdb" start_cmd="postgresql_command start" stop_cmd="postgresql_command stop" restart_cmd="postgresql_command restart" reload_cmd="postgresql_command reload" status_cmd="postgresql_command status" initdb_cmd="postgresql_initdb" if [ -n "$2" ]; then profile="$2" if [ "x${postgresql_profiles}" != "x" ]; then eval postgresql_data="\${postgresql_${profile}_data:-}" if [ "x${postgresql_data}" = "x" ]; then echo "You must define a data directory (postgresql_${profile}_data)" exit 1 fi eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}} eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}} eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}" eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}" fi else if [ "x${postgresql_profiles}" != "x" -a "x$1" != "x" ]; then for profile in ${postgresql_profiles}; do eval _enable="\${postgresql_${profile}_enable}" case "x${_enable:-${postgresql_enable}}" in x|x[Nn][Oo]|x[Nn][Oo][Nn][Ee]) continue ;; x[Yy][Ee][Ss]) ;; *) if test -z "$_enable"; then _var=postgresql_enable else _var=postgresql_"${profile}"_enable fi echo "Bad value" \ "'${_enable:-${postgresql_enable}}'" \ "for ${_var}. " \ "Profile ${profile} skipped." continue ;; esac echo "===> postgresql profile: ${profile}" %%PREFIX%%/etc/rc.d/postgresql $1 ${profile} retcode="$?" if [ "0${retcode}" -ne 0 ]; then failed="${profile} (${retcode}) ${failed:-}" else success="${profile} ${success:-}" fi done exit 0 fi fi command_args="-D ${postgresql_data} ${postgresql_flags}" postgresql_command() { su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}" } postgresql_initdb() { su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data}" } run_rc_command "$1"