To start the database server, execute the following system command as the root user.
bash-3.00# svcadm -v start -s application/jive/database svc:/application/jive/database:default started.
To stop the database server, execute the following system command as the root user.
bash-3.00# svcadm -v stop -s application/jive/database svc:/application/jive/database:default stopped.
Note that stopping the database while managed applications are using the database will result in applications that cannot service requests. Additionally, stopping the database while applications are connected may result in a lengthy shutdown time or a failed shutdown.
Monitoring the database server can be done as the root user with system scripts, or with traditional Unix commands.
To check the status of the jive database, execute the following command as the root user.
bash-3.00# svcs -l application/jive/database
A healthy, running database system will have multiple processes. The following command will show all running database processes on the system:
bash-3.00# ps -ef | grep post | grep -v grep jive 3211 1 0 17:13 ? 00:00:00 /usr/local/jive/postgres/bin/postgres -D /usr/local/jive/var/data/postgres-8.3 jive 3214 3211 0 17:13 ? 00:00:00 postgres: writer process jive 3215 3211 0 17:13 ? 00:00:00 postgres: wal writer process jive 3216 3211 0 17:13 ? 00:00:00 postgres: autovacuum launcher process jive 3217 3211 0 17:13 ? 00:00:00 postgres: archiver process jive 3218 3211 0 17:13 ? 00:00:00 postgres: stats collector process
In the default configuration, the included database service listens for connections on TCP address 127.0.0.1 port 5432. To verify that the database is listening for connections, execute the following command.
bash-3.00# lsof -n -P | grep jive | grep postgres | grep LISTEN
postgres 2990 jive 3u IPv4 21499 TCP 127.0.0.1:5432 (LISTEN)
Logs for the database server are maintained in the platform log directory at "/usr/local/jive/var/logs/postgres.log".