[BACK]Return to postgresql.sh CVS log [TXT][DIR] Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql11-server / files / smf
File: [cvs.NetBSD.org] / pkgsrc / databases / postgresql11-server / files / smf / Attic / postgresql.sh (download)

Revision 1.1, Tue Oct 23 16:02:52 2018 UTC (5 years, 5 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2023Q4-base, pkgsrc-2023Q4, pkgsrc-2023Q3-base, pkgsrc-2023Q3, pkgsrc-2023Q2-base, pkgsrc-2023Q2, pkgsrc-2023Q1-base, pkgsrc-2023Q1, pkgsrc-2022Q4-base, pkgsrc-2022Q4, pkgsrc-2022Q3-base, pkgsrc-2022Q3, pkgsrc-2022Q2-base, pkgsrc-2022Q2, pkgsrc-2022Q1-base, pkgsrc-2022Q1, pkgsrc-2021Q4-base, pkgsrc-2021Q4, pkgsrc-2021Q3-base, pkgsrc-2021Q3, pkgsrc-2021Q2-base, pkgsrc-2021Q2, pkgsrc-2021Q1-base, pkgsrc-2021Q1, pkgsrc-2020Q4-base, pkgsrc-2020Q4, pkgsrc-2020Q3-base, pkgsrc-2020Q3, pkgsrc-2020Q2-base, pkgsrc-2020Q2, pkgsrc-2020Q1-base, pkgsrc-2020Q1, pkgsrc-2019Q4-base, pkgsrc-2019Q4, pkgsrc-2019Q3-base, pkgsrc-2019Q3, pkgsrc-2019Q2-base, pkgsrc-2019Q2, pkgsrc-2019Q1-base, pkgsrc-2019Q1, pkgsrc-2018Q4-base, pkgsrc-2018Q4 

postgresql11: added version 11.0

PostgreSQL 11 provides users with improvements to overall performance of the database system, with specific enhancements associated with very large databases and high computational workloads. Further, PostgreSQL 11 makes significant improvements to the table partitioning system, adds support for stored procedures capable of transaction management, improves query parallelism and adds parallelized data definition capabilities, and introduces just-in-time (JIT) compilation for accelerating the execution of expressions in queries.

#!/sbin/sh
# Copyright 2006 Sun Microsystems, Inc. All rights reserved.
# Use is subject to license terms.
#
# ident "%Z%%M% %I% %E SMI"
. /lib/svc/share/smf_include.sh

# SMF_FMRI is the name of the target service. This allows multiple instances
# to use the same script.

getproparg()
{     val=`svcprop -p $1 $SMF_FMRI`
      [ -n "$val" ] && echo $val
}

PGBIN=@PREFIX@/bin
PGDATA=`getproparg config/data`
PGLOG=`getproparg config/log`

if [ -z $SMF_FMRI ]; then
     echo "SMF framework variables are not initialized."
     exit $SMF_EXIT_ERR
fi

if [ -z $PGDATA ]; then

     echo "postgresql/data property not set"
     exit $SMF_EXIT_ERR_CONFIG
fi

if [ -z $PGLOG ]; then

     echo "postgresql/log property not set"
     exit $SMF_EXIT_ERR_CONFIG
fi

case "$1" in
'start')
     ulimit -n 10240
     $PGBIN/pg_ctl -D $PGDATA -l $PGLOG start
     ;;

'stop')
     $PGBIN/pg_ctl -D $PGDATA stop
     ;;

'refresh')
     $PGBIN/pg_ctl -D $PGDATA reload
     ;;
*)

     echo $"Usage: $0 {start|refresh}"
     exit 1
     ;;

esac
exit $SMF_EXIT_OK