The Jive SBS platform ships with a local PostgreSQL database server. The following operations are available for the database server.
To start the database server, execute the following system command as the root user.
[root@biodome:~]$ /etc/init.d/jive-database start JIVE_HOME set to /usr/local/jive Starting jive-database: server starting
To stop the database server, execute the following system command as the root user.
[root@biodome:~]$ /etc/init.d/jive-database stop JIVE_HOME set to /usr/local/jive Stopping jive-database: waiting for server to shut down.... done server 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.
[root@biodome:~]$ /etc/init.d/jive-database status pg_ctl: server is running (PID: 3211) /usr/local/jive/postgres/bin/postgres "-D" "/usr/local/jive/var/data/postgres-8.3"
The output of the above command lists the parent process of the database system (3211 in this example) and shows the command used to start the database.
A healthy, running database system will have multiple processes. The following command will show all running database processes on the system:
[root@biodome:~]$ 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.
[root@melina ~]# 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".