Annotation of pkgsrc/databases/postgresql15-server/files/pgsql.sh, revision 1.3
1.1 adam 1: #!@RCD_SCRIPTS_SHELL@
2: #
1.3 ! adam 3: # $NetBSD: pgsql.sh,v 1.2 2024/02/09 08:33:15 adam 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:
1.2 adam 21: if [ -f @SYSCONFBASE@/rc.subr ]; then
22: . @SYSCONFBASE@/rc.subr
1.1 adam 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:
1.3 ! adam 43: if [ -f @SYSCONFBASE@/rc.subr -a -d @SYSCONFBASE@/rc.d -a -f @SYSCONFBASE@/rc.d/DAEMON ]; then
1.1 adam 44: load_rc_config $name
1.2 adam 45: elif [ -f @SYSCONFBASE@/rc.conf ]; then
46: . @SYSCONFBASE@/rc.conf
1.1 adam 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:
57: pgsql_precmd()
58: {
59: ulimit -n ${pgsql_nfiles}
60: if [ ! -d ${pgsql_home}/data/base ]; then
61: pgsql_initdb
62: fi
63: }
64:
65: pgsql_initdb()
66: {
67: if [ -d ${pgsql_home}/data/base ]; then
68: @ECHO@ "The PostgreSQL template databases have already been initialized."
69: @ECHO@ "Skipping database initialization."
70: else
71: @ECHO@ "Initializing PostgreSQL databases."
72: @MKDIR@ -p ${pgsql_home}
73: @CHOWN@ ${pgsql_user} ${pgsql_home}
74: @CHGRP@ ${pgsql_group} ${pgsql_home}
75: @CHMOD@ 0700 ${pgsql_home}
76: @SU@ -m ${pgsql_user} -c "${command} init ${command_args}"
77: fi
78: }
79:
80: pgsql_start()
81: {
82: @ECHO@ "Starting ${name}."
83: @SU@ -m ${pgsql_user} -c "${command} start ${command_args_daemon}"
84: }
85:
86: pgsql_restart()
87: {
88: @ECHO@ "Restarting ${name}."
89: @SU@ -m ${pgsql_user} -c "${command} restart ${command_args_daemon}"
90: }
91:
92: pgsql_stop()
93: {
94: @ECHO@ "Stopping ${name}."
95: @SU@ -m ${pgsql_user} -c "${command} stop ${command_args}"
96: }
97:
98: pgsql_reload()
99: {
100: @ECHO@ "Reloading ${name}."
101: @SU@ -m ${pgsql_user} -c "${command} reload ${command_args_daemon}"
102: }
103:
1.3 ! adam 104: if [ -f @SYSCONFBASE@/rc.subr -a -d @SYSCONFBASE@/rc.d -a -f @SYSCONFBASE@/rc.d/DAEMON ]; then
1.1 adam 105: run_rc_command "$1"
106: else
107: pidfile="${pgsql_home}/data/postmaster.pid"
108: case "$1" in
109: initdb)
110: eval ${initdb_cmd}
111: ;;
112: restart)
113: eval ${restart_precmd}
114: eval ${restart_cmd}
115: ;;
116: stop)
117: if [ -r "${pidfile}" ]; then
118: eval ${stop_cmd}
119: fi
120: ;;
121: reload)
122: eval ${reload_cmd}
123: ;;
124: *)
125: eval ${start_precmd}
126: eval ${start_cmd}
127: ;;
128: esac
129: fi
CVSweb <webmaster@jp.NetBSD.org>