summaryrefslogtreecommitdiffstats
path: root/abs/extra/postgresql/postgresql
blob: c6aedfb3b253dfcae84d2d0a8adaf28a91b76b60 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
#!/bin/bash

. /etc/rc.conf
. /etc/rc.d/functions
. /etc/conf.d/postgresql

case "$1" in
  start)
    stat_busy "Starting PostgreSQL"
    # initialization
    if [ ! `egrep '^postgres:' /etc/group` ]; then
      stat_busy "Adding postgres group"
      groupadd -g 88 postgres
      stat_done
    fi
    if [ ! `egrep '^postgres:' /etc/passwd` ]; then
      stat_busy "Adding postgres user"
      useradd -u 88 -g postgres -d $PGROOT -s /bin/bash postgres
      [ -d $PGROOT ] && chown -R postgres.postgres $PGROOT
      stat_done
    fi
    if [ ! -d $PGROOT ]; then
      mkdir -p $PGROOT/data && chown postgres.postgres $PGROOT/data
      su - postgres -c "/usr/bin/initdb -D $PGROOT/data"
    fi
    if [ ! -e /var/log/postgresql.log ]; then
      touch /var/log/postgresql.log
      chown postgres /var/log/postgresql.log
    fi
    # start the process
    su - postgres -c \
     "/usr/bin/pg_ctl -D $PGROOT/data -l /var/log/postgresql.log -W start"
    if [ $? -gt 0 ]; then
      stat_fail
    else
      add_daemon postgresql
      stat_done
    fi
    ;;
  stop)
    stat_busy "Stopping PostgreSQL"
    su - postgres -c \
      "/usr/bin/pg_ctl -D $PGROOT/data -l /var/log/postgresql.log -w stop"  
    if [ $? -gt 0 ]; then
      stat_fail
    else
      rm_daemon postgresql
      stat_done
    fi
    ;;
  restart)
    $0 stop
    sleep 3
    $0 start
    ;;
  *)
    echo "usage: $0 {start|stop|restart}"  
esac
exit 0