Postgresql

A pre-configured one-click install solution for PostgreSQL 9.6.1 server, a powerful, enterprise class open source object-relational database. It also includes self-management, self-monitoring and self-healing components.

Configuration

Full settings

config

Directories

Configurations: /jet/etc
Log files: /jet/log
Applications: /jet/app
Applications data: /jet/var
Temporary files: /jet/tmp

postgresql

Server configuration

Version: 9.6.1
Main config: /jet/etc/postgresql/postgresql.conf
Config directory: /jet/etc/postgresql
Database directory: /jet/var/postgresql/data
System database: postgres
Administrator username: postgres
Administrator password: password
Port: 5432
Socket: /tmp/.s.PGSQL.5432
Logfile: /jet/log/postgresql/postgresql.log

Daemon management

Start: start postgresql
Stop: stop postgresql
Restart: restart postgresql

monit

Settings

Version: 5.19.0
Main config: /jet/etc/monit/monitrc
Additional config files: /jet/etc/monit/monit.d
Logfile: /jet/log/monit/monit.log

Daemon management

Start: start monit
Stop: stop monit
Restart: restart monit
Reload: reload monit
Status: monit summary monit status

init

Services control

Available services: monit postgresql
Command to start all services: start
Command to stop all services: stop
Available commands: start|stop|status|restart servicename