# -*- coding: utf-8; mode: tcl; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- vim:fenc=utf-8:ft=tcl:et:sw=4:ts=4:sts=4
# Final release was on 2016-10-27
deprecated.upstream_support no
description run postgresql91 as server
long_description ${description}
homepage https://www.postgresql.org/
depends_run port:postgresql91
set libdir ${prefix}/lib/postgresql91
set dbdir ${prefix}/var/db/postgresql91/defaultdb
set logdir ${prefix}/var/log/postgresql91
set dbhome ${prefix}/var/db/postgresql91
add_users ${dbuser} shell=/bin/sh group=${dbgrp} \
realname=PostgreSQL-91\ Server
"PGCTL=${libdir}/bin/pg_ctl"
"su ${dbuser} -c \"\${PGCTL} -D \${POSTGRESQL91DATA:=${dbdir}} start -l ${logdir}/postgres.log\""
"su ${dbuser} -c \"\${PGCTL} -D \${POSTGRESQL91DATA:=${dbdir}} stop -s -m fast\""
xinstall -m 755 -d ${destroot}${logdir}
system "touch ${destroot}${logdir}/postgres.log"
system "chown ${dbuser}:${dbgrp} ${destroot}${logdir}/postgres.log"
notes "\nTo create a database instance, after install do\n\
sudo mkdir -p ${dbdir}\n\
sudo chown ${dbuser}:${dbgrp} ${dbdir}\n\
sudo su ${dbuser} -c \'cd ${dbhome} && ${libdir}/bin/initdb -D ${dbdir}\' \n\
\nTo tweak your DBMS, consider increasing kern.sysv.shmmax\
by adding an increased kern.sysv.shmmax .. to /etc/sysctl.conf"