# -*- 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

PortSystem 1.0
PortGroup deprecated 1.0

# Final release was on 2017-11-09
deprecated.upstream_support no

name			postgresql92-server
version			9.2.24
categories		databases
platforms		{darwin any}
supported_archs	noarch
maintainers		nomaintainer
license			Permissive
description		run postgresql92 as server
long_description	{*}${description}
distfiles       

homepage		https://www.postgresql.org/
master_sites		postgresql

depends_run		port:postgresql92

supported_archs     noarch

use_configure	no
build	{}

set libdir		${prefix}/lib/postgresql92
set dbdir		${prefix}/var/db/postgresql92/defaultdb
set logdir		${prefix}/var/log/postgresql92
set dbuser		postgres
set dbgrp		postgres
set dbhome		${prefix}/var/db/postgresql92

add_users ${dbuser} shell=/bin/sh group=${dbgrp} \
    home=${dbhome} \
    realname=PostgreSQL-92\ Server

startupitem.create	yes
startupitem.init	\
	"PGCTL=${libdir}/bin/pg_ctl"
startupitem.start	\
	"su ${dbuser} -c \"\${PGCTL} -D \${POSTGRESQL92DATA:=${dbdir}} start -l ${logdir}/postgres.log\""
startupitem.stop	\
"su ${dbuser} -c \"\${PGCTL} -D \${POSTGRESQL92DATA:=${dbdir}} stop -s -m fast\""

destroot {
	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"

livecheck.type	none