# -*- 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 compiler_blacklist_versions 1.0
PortGroup muniversal 1.0
PortGroup deprecated 1.0

# Final release was on 2021-02-08
deprecated.upstream_support no

#remember to update the -doc and -server as well
name			postgresql95
version			9.5.25
revision        2

categories		databases
maintainers		{jwa @jyrkiwahlstedt}
license			Permissive
description		The most advanced open-source database available anywhere.
long_description PostgreSQL is Object-Relational Database Management System. \
				It supports almost all SQL constructs, including transactions, \
				subselects, and user-defined types and functions. Write-ahead \
				logging means increased performance while retaining data \
				integrity.

homepage		https://www.postgresql.org/
master_sites		http://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org/source/v${version}/ \
			postgresql:source/v${version}/
distname		postgresql-${version}

checksums           rmd160  29bc5f749edd9b3f45d133f970a593dd610b72fb \
                    sha256  7628c55eb23768a2c799c018988d8f2ab48ee3d80f5e11259938f7a935f0d603 \
                    size    17923796

use_bzip2		yes

# do not build man or html files (use postgresqlXY-doc instead)
patchfiles-append   patch-no_doc.diff

# https://www.postgresql.org/message-id/attachment/152769/v1-0001-Make-PostgreSQL-work-with-newer-version-of-libxml.patch
# diff -NaurdwB ./postgresql95-orig ./postgresql95-new | sed -E -e 's/\.\/postgresql95-(orig|new)/\./g' | sed -E -e 's|/opt/local|@@PREFIX@@|g' > ~/Downloads/patch-xml_c.diff
patchfiles-append   patch-xml_c.diff

depends_lib		port:readline path:lib/libssl.dylib:openssl port:zlib port:libxml2 port:libxslt
depends_build		port:bison
depends_run		port:postgresql_select-95

worksrcdir		postgresql-${version}

set libdir		${prefix}/lib/${name}
configure.args	PG_SYSROOT=disabled \
				--sysconfdir=${prefix}/etc/${name} \
				--bindir=${libdir}/bin \
				--libdir=${libdir} \
				--includedir=${prefix}/include/${name} \
				--datadir=${prefix}/share/${name} \
                --docdir=${prefix}/share/doc/${name} \
				--mandir=${prefix}/share/man \
				--with-includes=${prefix}/include \
				--with-libraries=${prefix}/lib \
				--with-openssl \
				--with-bonjour \
				--with-readline \
				--with-zlib \
				--with-libxml \
				--with-libxslt \
                --with-gssapi \
				--enable-thread-safety \
				--with-uuid=e2fs

configure.ldflags-append    -headerpad_max_install_names
configure.universal_args-delete --disable-dependency-tracking

# building psql with clang from Xcode prior to 4.4 causes segfault on query; see #31717
compiler.blacklist-append {clang < 421}
notes "To use the postgresql server, install the ${name}-server port"

if {![info exists universal_possible]} {
    set universal_possible [expr {${os.universal_supported} && [llength ${configure.universal_archs}] >= 2}]
}
if {${universal_possible} && [variant_isset universal]} {
    configure.cflags-append	-DAC_APPLE_UNIVERSAL_BUILD
}

build.type		gnu
build.target    world

destroot.target install-world

test.run		yes
test.target		check

# remember to change livecheck with first proper release
livecheck.type	regex
#livecheck.regex	(9\\.5\[.0-9\]*\[a-z\]+\[0-9\])
livecheck.regex	(9\\.5\\.\[.0-9\]+)
livecheck.url	${homepage}/ftp/source/

post-destroot {
	system "cd ${destroot}${prefix}/bin && ln -sf ${libdir}/bin/psql psql95"

	reinplace -E "s#^CFLAGS =#CFLAGS +=#g" \
	    ${destroot}${prefix}/lib/${name}/pgxs/src/Makefile.global

	reinplace -E "s#^(\[\[:space:\]\]+)LDFLAGS =#\\1LDFLAGS +=#g" \
	    ${destroot}${prefix}/lib/${name}/pgxs/src/Makefile.global
}

if {!${universal_possible} || ![variant_isset universal]} {
    post-destroot {
        reinplace -E "s#-arch\[\[:space:\]\]+\[\[:alnum:\]_\]+##g" \
            ${destroot}${prefix}/lib/${name}/pgxs/src/Makefile.global
    }
} else {
    merger-post-destroot {
        foreach arch ${configure.universal_archs} {
            reinplace -E "s#-arch\[\[:space:\]\]+\[\[:alnum:\]_\]+##g" \
                ${destroot}-${arch}${prefix}/lib/${name}/pgxs/src/Makefile.global

            reinplace -E "s#${worksrcpath}-${arch}#${worksrcpath}#g" \
                ${destroot}-${arch}${prefix}/lib/${name}/pgxs/src/Makefile.global
        }
    }
}

variant python requires python27 description {add support for python} {
}

variant python27 conflicts python3 description {add support for python 2.7} {
	depends_lib-append		port:python27
	configure.args-append	--with-python
	configure.python		${prefix}/bin/python2.7
}

variant python3 conflicts python27 description {add support for python 3.x} {
	depends_lib-append		port:python38
	configure.args-append	--with-python
	configure.python		${prefix}/bin/python3.8
}

variant perl description {add Perl support} {
	depends_lib-append			bin:perl:perl5
	configure.args-append		--with-perl
}

variant tcl description {add Tcl support} {
	depends_lib-append			port:tcl
	configure.args-append		--with-tcl --with-tclconfig=${prefix}/lib
	configure.env-append		TCLSH=${prefix}/bin/tclsh
}