Annotation of pkgsrc/databases/postgresql18-server/files/pgsql.sh, revision 1.3

1.1       adam        1: #!@RCD_SCRIPTS_SHELL@
                      2: #
1.3     ! gdt         3: # $NetBSD: pgsql.sh,v 1.2 2026/10/02 18:11:09 gdt Exp $
1.1       adam        4: #
                      5: # PostgreSQL database rc.d control script
                      6: #
                      7: # PROVIDE: pgsql
                      8: # REQUIRE: DAEMON
                      9: # KEYWORD: shutdown
                     10: #
                     11: # You will need to set some variables in /etc/rc.conf to start PostgreSQL:
                     12: #
                     13: # pgsql=YES
                     14: #
                     15: # Optionally, "pgsql_flags" contains options for the PostgreSQL postmaster, e.g.
                     16: #      pgsql_flags="-i"                # allows TCP/IP connections
                     17: #      pgsql_flags="-i -l"             # enables SSL connections
                     18: #      pgsql_home="/path/to/home"      # path to pgsql database directory
                     19: # See postmaster(1) for possible options.
                     20: 
                     21: if [ -f @SYSCONFBASE@/rc.subr ]; then
                     22:   . @SYSCONFBASE@/rc.subr
                     23: fi
                     24: 
                     25: name="pgsql"
                     26: rcvar=${name}
                     27: command="@PREFIX@/bin/pg_ctl"
                     28: procname="@PREFIX@/bin/postgres"
                     29: : ${pgsql_user:=@PGUSER@}
                     30: : ${pgsql_group:=@PGGROUP@}
                     31: : ${pgsql_home:=@PGHOME@}
                     32: 
                     33: pgsql_nfiles=4096
                     34: extra_commands="initdb reload"
                     35: initdb_cmd="pgsql_initdb"
                     36: start_precmd="pgsql_precmd"
                     37: start_cmd="pgsql_start"
                     38: restart_precmd="pgsql_precmd"
                     39: restart_cmd="pgsql_restart"
                     40: stop_cmd="pgsql_stop"
                     41: reload_cmd="pgsql_reload"
                     42: 
                     43: if [ -f @SYSCONFBASE@/rc.subr -a -d @SYSCONFBASE@/rc.d -a -f @SYSCONFBASE@/rc.d/DAEMON ]; then
                     44:        load_rc_config $name
                     45: elif [ -f @SYSCONFBASE@/rc.conf ]; then
                     46:        . @SYSCONFBASE@/rc.conf
                     47: fi
                     48: 
                     49: cd /
                     50: 
                     51: command_args="-w -s -D ${pgsql_home}/data -m fast -l ${pgsql_home}/errlog"
                     52: command_args_daemon="${command_args}"
                     53: if [ -n "${pgsql_flags}" ]; then
                     54:        command_args_daemon="${command_args} -o \"${pgsql_flags}\""
                     55: fi
                     56: 
1.3     ! gdt        57: # If the sysctl named by the first arg is less than the second arg,
        !            58: # print a warning.
        !            59: check_sysctl()
        !            60: {
        !            61:     var=$1
        !            62:     limit=$2
        !            63:     value=`sysctl $var | @AWK@ '{print $3}'`
        !            64:     if [ "$value" -lt "$limit" ]; then
        !            65:        @ECHO@ "WARNING: pgsql: sysctl $var = $value IS LESS THAN $limit"
        !            66:     fi
        !            67: }
        !            68: 
1.1       adam       69: pgsql_precmd()
                     70: {
                     71:        ulimit -n ${pgsql_nfiles}
1.3     ! gdt        72:        case `uname` in
        !            73:            NetBSD)
        !            74:                check_sysctl kern.ipc.semmni 32
        !            75:                check_sysctl kern.ipc.semmns 256
        !            76:                ;;
        !            77:        esac
1.1       adam       78:        if [ ! -d ${pgsql_home}/data/base ]; then
                     79:                pgsql_initdb
                     80:        fi
                     81: }
                     82: 
                     83: pgsql_initdb()
                     84: {
                     85:        if [ -d ${pgsql_home}/data/base ]; then
                     86:                @ECHO@ "The PostgreSQL template databases have already been initialized."
                     87:                @ECHO@ "Skipping database initialization."
                     88:        else
                     89:                @ECHO@ "Initializing PostgreSQL databases."
1.2       gdt        90:                @MKDIR@ ${pgsql_home}
1.1       adam       91:                @CHOWN@ ${pgsql_user} ${pgsql_home}
                     92:                @CHGRP@ ${pgsql_group} ${pgsql_home}
                     93:                @CHMOD@ 0700 ${pgsql_home}
                     94:                @SU@ -m ${pgsql_user} -c "${command} init ${command_args}"
                     95:        fi
                     96: }
                     97: 
                     98: pgsql_start()
                     99: {
                    100:        @ECHO@ "Starting ${name}."
                    101:        @SU@ -m ${pgsql_user} -c "${command} start ${command_args_daemon}"
                    102: }
                    103: 
                    104: pgsql_restart()
                    105: {
                    106:        @ECHO@ "Restarting ${name}."
                    107:        @SU@ -m ${pgsql_user} -c "${command} restart ${command_args_daemon}"
                    108: }
                    109: 
                    110: pgsql_stop()
                    111: {
                    112:        @ECHO@ "Stopping ${name}."
                    113:        @SU@ -m ${pgsql_user} -c "${command} stop ${command_args}"
                    114: }
                    115: 
                    116: pgsql_reload()
                    117: {
                    118:        @ECHO@ "Reloading ${name}."
                    119:        @SU@ -m ${pgsql_user} -c "${command} reload ${command_args_daemon}"
                    120: }
                    121: 
                    122: if [ -f @SYSCONFBASE@/rc.subr -a -d @SYSCONFBASE@/rc.d -a -f @SYSCONFBASE@/rc.d/DAEMON ]; then
                    123:        run_rc_command "$1"
                    124: else
                    125:        pidfile="${pgsql_home}/data/postmaster.pid"
                    126:        case "$1" in
                    127:        initdb)
                    128:                eval ${initdb_cmd}
                    129:                ;;
                    130:        restart)
                    131:                eval ${restart_precmd}
                    132:                eval ${restart_cmd}
                    133:                ;;
                    134:        stop)
                    135:                if [ -r "${pidfile}" ]; then
                    136:                        eval ${stop_cmd}
                    137:                fi
                    138:                ;;
                    139:        reload)
                    140:                eval ${reload_cmd}
                    141:                ;;
                    142:        *)
                    143:                eval ${start_precmd}
                    144:                eval ${start_cmd}
                    145:                ;;
                    146:        esac
                    147: fi

CVSweb <webmaster@jp.NetBSD.org>