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>