Annotation of pkgsrc/databases/postgresql16-server/files/pgsql.sh, revision 1.2
1.1 adam 1: #!@RCD_SCRIPTS_SHELL@
2: #
1.2 ! triaxx 3: # $NetBSD: pgsql.sh,v 1.1 2023/09/17 08:53:22 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 ! triaxx 21: $_rc_subr_loaded . @SYSCONFBASE@/rc.subr
1.1 adam 22:
23: name="pgsql"
24: rcvar=${name}
25: command="@PREFIX@/bin/pg_ctl"
26: procname="@PREFIX@/bin/postgres"
27: : ${pgsql_user:=@PGUSER@}
28: : ${pgsql_group:=@PGGROUP@}
29: : ${pgsql_home:=@PGHOME@}
30:
31: pgsql_nfiles=4096
32: extra_commands="initdb reload"
33: initdb_cmd="pgsql_initdb"
34: start_precmd="pgsql_precmd"
35: start_cmd="pgsql_start"
36: restart_precmd="pgsql_precmd"
37: restart_cmd="pgsql_restart"
38: stop_cmd="pgsql_stop"
39: reload_cmd="pgsql_reload"
40:
1.2 ! triaxx 41: if [ -f @SYSCONFBASE@/rc.subr ] && \
! 42: [ -d @SYSCONFBASE@/rc.d ] && \
! 43: [ -f @SYSCONFBASE@/rc.d/DAEMON ]; then
1.1 adam 44: load_rc_config $name
1.2 ! triaxx 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.2 ! triaxx 104: if [ -f @SYSCONFBASE@/rc.subr ] && \
! 105: [ -d @SYSCONFBASE@/rc.d ] && \
! 106: [ -f @SYSCONFBASE@/rc.d/DAEMON ]; then
1.1 adam 107: run_rc_command "$1"
108: else
109: pidfile="${pgsql_home}/data/postmaster.pid"
110: case "$1" in
111: initdb)
112: eval ${initdb_cmd}
113: ;;
114: restart)
115: eval ${restart_precmd}
116: eval ${restart_cmd}
117: ;;
118: stop)
119: if [ -r "${pidfile}" ]; then
120: eval ${stop_cmd}
121: fi
122: ;;
123: reload)
124: eval ${reload_cmd}
125: ;;
126: *)
127: eval ${start_precmd}
128: eval ${start_cmd}
129: ;;
130: esac
131: fi
CVSweb <webmaster@jp.NetBSD.org>