# This is the PostgreSQL Global Development Group Official RPMset spec file,

# or a derivative thereof.

# Copyright 2003-2009 Lamar Owen <lowen@pari.edu> <lamar.owen@wgcr.org>

# and others listed.

# Major Contributors:

# ---------------

# Lamar Owen

# Trond Eivind Glomsrd <teg@redhat.com>

# Thomas Lockhart

# Reinhard Max

# Karl DeBisschop

# Peter Eisentraut

# Joe Conway

# Andrew Overholt

# David Jee

# Kaj J. Niemi

# Sander Steffann

# Tom Lane

# and others in the Changelog....

# This spec file and ancillary files are licensed in accordance with

# The PostgreSQL license.

# In this file you can find the default build package list macros.

# These can be overridden by defining on the rpm command line:

# rpm --define 'packagename 1' .... to force the package to build.

# rpm --define 'packagename 0' .... to force the package NOT to build.

# The base package, the libs package, the devel package, and the server package

# always get built.

%{?scl:%scl_package postgresql}

%{!?beta:%global beta 0}

%{?beta:%global __os_install_post /usr/lib/rpm/brp-compress}

%{!?test:%global test 1}

%{!?upgrade:%global upgrade 1}

%{!?plpython:%global plpython 1}

%{!?plpython3:%global plpython3 0}

%{!?pltcl:%global pltcl 1}

%{!?plperl:%global plperl 1}

%{!?ssl:%global ssl 1}

%{!?kerberos:%global kerberos 1}

%{!?ldap:%global ldap 1}

%{!?nls:%global nls 1}

%{!?uuid:%global uuid 1}

%{!?xml:%global xml 1}

%{!?pam:%global pam 1}

%{!?sdt:%global sdt 1}

%{!?selinux:%global selinux 1}

%{!?runselftest:%global runselftest 1}

# By default, patch(1) creates backup files when chunks apply with offsets.

# Turn that off to ensure such files don't get included in RPMs.

%global _default_patch_flags --no-backup-if-mismatch

%if 0%{?scl:1}

%global scl_upper %{lua:print(string.upper(string.gsub(rpm.expand("%{scl}"), "-", "_")))}

%endif

%{!?_pkgdocdir: %global _pkgdocdir %{_docdir}/%{name}-%{version}}

# https://fedoraproject.org/wiki/Packaging:Guidelines#Packaging_of_Additional_RPM_Macros

%global macrosdir %(d=%{_rpmconfigdir}/macros.d; [ -d $d ] || d=%{!?scl:%_sysconfdir}%{?scl:%_root_sysconfdir}/rpm; echo $d)

Summary: PostgreSQL client programs

Name: %{?scl_prefix}postgresql

%global majorversion 9.4

Version: 9.4.14

Release: 2%{?dist}

# The PostgreSQL license is very similar to other MIT licenses, but the OSI

# recognizes it as an independent license, so we do as well.

License: PostgreSQL

Group: Applications/Databases

Url: http://www.postgresql.org/

%global setup_version 6.0

%global service_name %{?scl_prefix}postgresql.service

Source0: ftp://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2

# The PDF file is generated by generate-pdf.sh, which see for comments

Source1: postgresql-%{version}-US.pdf

# generate-pdf.sh is not used during RPM build, but include for documentation

Source2: generate-pdf.sh

Source5: Makefile.regress

Source6: pg_config.h

Source7: ecpg_config.h

Source13: postgresql.tmpfiles.d

Source14: postgresql.pam

Source15: postgresql-bashprofile

# http://fedorapeople.org/cgit/praiskup/public_git/postgresql-setup.git/

Source16: http://praiskup.fedorapeople.org/proj/postgresql-setup/postgresql-setup-%{setup_version}.tar.gz

# Comments for these patches are in the patch files.

Patch1: rpm-pgsql.patch

Patch2: postgresql-logging.patch

Patch3: postgresql-perl-rpath.patch

Patch4: postgresql-config-comment.patch

Patch6: postgresql-var-run-socket.patch

Patch8: postgresql-man.patch

Patch9: postgresql-socket-dirs-pgupgrade.patch

BuildRequires: perl(ExtUtils::MakeMaker) glibc-devel bison flex gawk

BuildRequires: perl(ExtUtils::Embed)

BuildRequires: readline-devel zlib-devel

# postgresql-setup build requires

BuildRequires: m4 elinks docbook-utils help2man

%if 0%{?rhel} >= 6

BuildRequires: perl-devel

%endif

BuildRequires: systemd

%if %plpython

BuildRequires: python-devel

%endif

%if %plpython3

BuildRequires: python3-devel

%endif

%if %pltcl

BuildRequires: tcl-devel

%endif

%if %ssl

BuildRequires: openssl-devel

%endif

%if %kerberos

BuildRequires: krb5-devel

%endif

%if %ldap

BuildRequires: openldap-devel

%endif

%if %nls

BuildRequires: gettext >= 0.10.35

%endif

%if %uuid

BuildRequires: uuid-devel

%endif

%if %xml

BuildRequires: libxml2-devel libxslt-devel

%endif

%if %pam

BuildRequires: pam-devel

%endif

%if %sdt

BuildRequires: systemtap-sdt-devel

%endif

%if %selinux

BuildRequires: libselinux-devel

%endif

# main package requires -libs subpackage

Requires: %{name}-libs%{?_isa} = %{version}-%{release}

%{?scl:Requires:%scl_runtime}

%description

PostgreSQL is an advanced Object-Relational database management system (DBMS).

The base postgresql package contains the client programs that you'll need to

access a PostgreSQL DBMS server, as well as HTML documentation for the whole

system.  These client programs can be located on the same machine as the

PostgreSQL server, or on a remote machine that accesses a PostgreSQL server

over a network connection.  The PostgreSQL server can be found in the

postgresql-server sub-package.

%package libs

Summary: The shared libraries required for any PostgreSQL clients

Group: Applications/Databases

# for /sbin/ldconfig

Requires(post): glibc

Requires(postun): glibc

%{?scl:Requires:%scl_runtime}

%description libs

The postgresql-libs package provides the essential shared libraries for any 

PostgreSQL client program or interface. You will need to install this package

to use any other PostgreSQL package or any clients that need to connect to a

PostgreSQL server.

%package server

Summary: The programs needed to create and run a PostgreSQL server

Group: Applications/Databases

Requires: %{name}%{?_isa} = %{version}-%{release}

Requires: %{name}-libs%{?_isa} = %{version}-%{release}

Requires: /usr/bin/scl_source

Requires(pre): /usr/sbin/useradd

# We require this to be present for %%{_prefix}/lib/tmpfiles.d

Requires: systemd

# Make sure it's there when scriptlets run, too

Requires(post): systemd

Requires(preun): systemd

Requires(postun): systemd

%{?scl:Requires:%scl_runtime}

%description server

PostgreSQL is an advanced Object-Relational database management system (DBMS).

The postgresql-server package contains the programs needed to create

and run a PostgreSQL server, which will in turn allow you to create

and maintain PostgreSQL databases.

%package docs

Summary: Extra documentation for PostgreSQL

Group: Applications/Databases

Requires: %{name}%{?_isa} = %{version}-%{release}

%{?scl:Requires:%scl_runtime}

%description docs

The postgresql-docs package contains some additional documentation for

PostgreSQL.  Currently, this includes the main documentation in PDF format

and source files for the PostgreSQL tutorial.

%package contrib

Summary: Extension modules distributed with PostgreSQL

Group: Applications/Databases

Requires: %{name}%{?_isa} = %{version}-%{release}

Requires: %{name}-libs%{?_isa} = %{version}-%{release}

%{?scl:Requires:%scl_runtime}

%description contrib

The postgresql-contrib package contains various extension modules that are

included in the PostgreSQL distribution.

%package devel

Summary: PostgreSQL development header files and libraries

Group: Development/Libraries

Requires: %{name}%{?_isa} = %{version}-%{release}

Requires: %{name}-libs%{?_isa} = %{version}-%{release}

%description devel

The postgresql-devel package contains the header files and libraries

needed to compile C or C++ applications which will directly interact

with a PostgreSQL database management server.  It also contains the ecpg

Embedded C Postgres preprocessor. You need to install this package if you want

to develop applications which will interact with a PostgreSQL server.

%package static

Summary: Statically linked PostgreSQL libraries

Requires: %{name}-devel%{?_isa} = %{version}-%{release}

%description static

Statically linked PostgreSQL libraries that do not have dynamically linked

counterparts.

%if %upgrade

%package upgrade

Summary: Support for upgrading from the previous major release of PostgreSQL

Group: Applications/Databases

Requires: %{name}-server%{?_isa} = %{version}-%{release}

Requires: %{name}-libs%{?_isa} = %{version}-%{release}

%{?scl:Requires:%scl_runtime}

%description upgrade

The postgresql-upgrade package contains the pg_upgrade utility and supporting

files needed for upgrading a PostgreSQL database from the core system version

of PostgreSQL.

%endif

%if %plperl

%package plperl

Summary: The Perl procedural language for PostgreSQL

Group: Applications/Databases

Requires: %{name}-server%{?_isa} = %{version}-%{release}

Requires: perl(:MODULE_COMPAT_%(eval "`%{__perl} -V:version`"; echo $version))

%{?scl:Requires:%scl_runtime}

%description plperl

The postgresql-plperl package contains the PL/Perl procedural language,

which is an extension to the PostgreSQL database server.

Install this if you want to write database functions in Perl.

%endif

%if %plpython

%package plpython

Summary: The Python2 procedural language for PostgreSQL

Group: Applications/Databases

Requires: %{name}-server%{?_isa} = %{version}-%{release}

%{?scl:Requires:%scl_runtime}

%description plpython

The postgresql-plpython package contains the PL/Python procedural language,

which is an extension to the PostgreSQL database server.

Install this if you want to write database functions in Python 2.

%endif

%if %plpython3

%package plpython3

Summary: The Python3 procedural language for PostgreSQL

Group: Applications/Databases

Requires: %{name}-server%{?_isa} = %{version}-%{release}

%{?scl:Requires:%scl_runtime}

%description plpython3

The postgresql-plpython3 package contains the PL/Python3 procedural language,

which is an extension to the PostgreSQL database server.

Install this if you want to write database functions in Python 3.

%endif

%if %pltcl

%package pltcl

Summary: The Tcl procedural language for PostgreSQL

Group: Applications/Databases

Requires: %{name}-server%{?_isa} = %{version}-%{release}

Requires: tcl-pgtcl

%{?scl:Requires:%scl_runtime}

%description pltcl

The postgresql-pltcl package contains the PL/Tcl procedural language,

which is an extension to the PostgreSQL database server.

Install this if you want to write database functions in Tcl.

%endif

%if %test

%package test

Summary: The test suite distributed with PostgreSQL

Group: Applications/Databases

Requires: %{name}-server%{?_isa} = %{version}-%{release}

Requires: %{name}-devel%{?_isa} = %{version}-%{release}

%{?scl:Requires:%scl_runtime}

%description test

The postgresql-test package contains files needed for various tests for the

PostgreSQL database management system, including regression tests and

benchmarks.

%endif

%prep

%setup -q %{?scl:-n %{pkg_name}-%{version}} -a 16

%patch1 -p1

%patch2 -p1

%patch3 -p1

%patch4 -p1

%patch6 -p1

%patch8 -p1

%patch9 -p1

# We used to run autoconf here, but there's no longer any real need to,

# since Postgres ships with a reasonably modern configure script.

# add ppc64p7 support (https://fedoraproject.org/wiki/Features/Power7Subarch)

# hopefully need for this will go away next time upstream updates config.sub

sed -i -e "s/ppc64-\*/ppc64-\* \| ppc64p7-\*/" config/config.sub

cp -p %{SOURCE1} .

# We need to add an extra setting of SCL environment into the service file

# and some checks into scripts that can be possibly run without scl enable,

# but only if we build the package in SCL environment. 

cp -p %{SOURCE15} .

%if 0%{?scl:1}

%global scl_sed_patches 1

%if %scl_sed_patches

find . -type f -name Makefile -exec sed -i -e "s/SO_MAJOR_VERSION=\s\?\([0-9]\+\)/SO_MAJOR_VERSION= %{?scl}-\1/" {} \;

%endif

%endif

# remove .gitignore files to ensure none get into the RPMs (bug #642210)

find . -type f -name .gitignore | xargs rm

%build

# fail quickly and obviously if user tries to build as root

%if %runselftest

	if [ x"`id -u`" = x0 ]; then

		echo "postgresql's regression tests fail if run as root."

		echo "If you really need to build the RPM as root, use"

		echo "--define='runselftest 0' to skip the regression tests."

		exit 1

	fi

%endif

CFLAGS="${CFLAGS:-%optflags}" ; export CFLAGS

# Strip out -ffast-math from CFLAGS....

CFLAGS=`echo $CFLAGS|xargs -n 1|grep -v ffast-math|xargs -n 100`

# Add LINUX_OOM_SCORE_ADJ=0 to ensure child processes reset postmaster's oom_score_adj

CFLAGS="$CFLAGS -DLINUX_OOM_SCORE_ADJ=0"

# let's try removing this kluge, it may just be a workaround for bz#520916

# # use -O1 on sparc64 and alpha

# %%ifarch sparc64 alpha

# CFLAGS=`echo $CFLAGS| sed -e "s|-O2|-O1|g" `

# %%endif

cd postgresql-setup-%{setup_version}

%configure \

    pgdocdir=%{_pkgdocdir} \

    PGVERSION=%{version} \

    PGMAJORVERSION=%{majorversion} \

%if 0%{?scl:1}

    SCLS=%{?scl} \

    NAME_SRV_PFX=%{?scl}- \

    NAME_PKG_PFX=%{?scl}- \

%endif

    NAME_DEFAULT_PREV_SERVICE=postgresql

make %{?_smp_mflags}

cd ..

# plpython requires separate configure/build runs to build against python 2

# versus python 3.  Our strategy is to do the python 3 run first, then make

# distclean and do it again for the "normal" build.  Note that the installed

# Makefile.global will reflect the python 2 build, which seems appropriate

# since that's still considered the default plpython version.

%if %plpython3

export PYTHON=/usr/bin/python3

# These configure options must match main build

%configure --disable-rpath \

%if %beta

	--enable-debug \

	--enable-cassert \

%endif

%if %plperl

	--with-perl \

%endif

%if %pltcl

	--with-tcl \

	--with-tclconfig=%{?scl:%_root_libdir}%{!?scl:%_libdir} \

%endif

%if %plpython3

	--with-python \

%endif

%if %ldap

	--with-ldap \

%endif

%if %ssl

	--with-openssl \

%endif

%if %pam

	--with-pam \

%endif

%if %kerberos

	--with-krb5 \

	--with-gssapi \

%endif

%if %uuid

	--with-ossp-uuid \

%endif

%if %xml

	--with-libxml \

	--with-libxslt \

%endif

%if %nls

	--enable-nls \

%endif

%if %sdt

	--enable-dtrace \

%endif

%if 0{!%selinux:1}

	--with-selinux \

%endif

	--with-system-tzdata=%{?scl:%_root_datadir}%{!?scl:%_datadir}/zoneinfo \

	--datadir=%{_datadir}/pgsql

# Fortunately we don't need to build much except plpython itself

cd src/backend

make submake-errcodes

cd ../..

cd src/pl/plpython

make %{?_smp_mflags} all

cd ..

# save built form in a directory that "make distclean" won't touch

cp -a plpython plpython3

cd ../..

# must also save this version of Makefile.global for later

cp src/Makefile.global src/Makefile.global.python3

make distclean

%endif

unset PYTHON

# Normal (not python3) build begins here

# we want to build with rpath since LD_LIBRARY_PATH is not strong enough

# for running pg_ctl under runuser command

%configure --disable-rpath \

%if %beta

	--enable-debug \

	--enable-cassert \

%endif

%if %plperl

	--with-perl \

%endif

%if %pltcl

	--with-tcl \

	--with-tclconfig=%{?scl:%_root_libdir}%{!?scl:%_libdir} \

%endif

%if %plpython

	--with-python \

%endif

%if %ldap

	--with-ldap \

%endif

%if %ssl

	--with-openssl \

%endif

%if %pam

	--with-pam \

%endif

%if %kerberos

	--with-krb5 \

	--with-gssapi \

%endif

%if %uuid

	--with-ossp-uuid \

%endif

%if %xml

	--with-libxml \

	--with-libxslt \

%endif

%if %nls

	--enable-nls \

%endif

%if %sdt

	--enable-dtrace \

%endif

%if %selinux

	--with-selinux \

%endif

	--with-system-tzdata=%{?scl:%_root_datadir}%{!?scl:%_datadir}/zoneinfo \

	--datadir=%{_datadir}/pgsql

make %{?_smp_mflags} world

# Have to hack makefile to put correct path into tutorial scripts

sed "s|C=\`pwd\`;|C=%{_libdir}/pgsql/tutorial;|" < src/tutorial/Makefile > src/tutorial/GNUmakefile

make %{?_smp_mflags} -C src/tutorial NO_PGXS=1 all

rm -f src/tutorial/GNUmakefile

# The object files shouldn't be copied to rpm bz#1187514

rm -f src/tutorial/*.o

test_failure=0

# run_testsuite WHERE

# -------------------

# Run 'make check' in WHERE path.  When that command fails, return the logs

# given by PostgreSQL build system and set 'test_failure=1'.

run_testsuite()

{

	make -C "$1" MAX_CONNECTIONS=5 check && return 0

	test_failure=1

	(

		set +x

		find "$1" -name 'regression.diffs' | \

		while read line; do

			echo "=== make failure: $line ==="

			cat "$line"

		done

	)

}

%if %runselftest

	run_testsuite "src/test/regress"

	make clean -C "src/test/regress"

	run_testsuite "src/pl"

%if %plpython3

	# must install Makefile.global that selects python3

	mv src/Makefile.global src/Makefile.global.save

	cp src/Makefile.global.python3 src/Makefile.global

	touch -r src/Makefile.global.save src/Makefile.global

	# because "make check" does "make install" on the whole tree,

	# we must temporarily install plpython3 as src/pl/plpython,

	# since that is the subdirectory src/pl/Makefile knows about

	mv src/pl/plpython src/pl/plpython2

	mv src/pl/plpython3 src/pl/plpython

	run_testsuite "src/pl/plpython"

	# and clean up our mess

	mv src/pl/plpython src/pl/plpython3

	mv src/pl/plpython2 src/pl/plpython

	mv -f src/Makefile.global.save src/Makefile.global

%endif

	run_testsuite "contrib"

%endif

# "assert(ALL_TESTS_OK)"

test "$test_failure" -eq 0

%if %test

	# undo the "make clean" above

	make all -C src/test/regress

%endif

%install

cd postgresql-setup-%{setup_version}

make install DESTDIR=$RPM_BUILD_ROOT

cd ..

# For some reson, specifying %doc %{_pkgdocdir}/README.rpm-dist in %files does

# not work (at least on RHEL6) and rpmbuild fails with (it may be known issue

# but I was unable to debug properly yet):

#   error: create archive failed on file

#   /builddir/.../...-9.4.1/README.rpm-dist: cpio: Bad magic

mv $RPM_BUILD_ROOT/%{_pkgdocdir}/README.rpm-dist ./

cat > $RPM_BUILD_ROOT%{_sysconfdir}/postgresql-setup/upgrade/postgresql.conf <

id              postgresql

major           9.2

data_default    /var/lib/pgsql/data

engine          /usr/bin

description     "Upgrade data from system PostgreSQL version (PostgreSQL 9.2)"

redhat_sockets_hack yes

EOF

cat > $RPM_BUILD_ROOT%{_sysconfdir}/postgresql-setup/upgrade/postgresql92.conf <

id              postgresql92-postgresql

major           9.2

data_default    /opt/rh/postgresql92/root/var/lib/pgsql/data

engine          /opt/rh/postgresql92/root/usr/bin

description     "Upgrade data from RHSCL 1.X PostgreSQL version (PostgreSQL 9.2)"

scls            "postgresql92"

redhat_sockets_hack yes

EOF

make DESTDIR=$RPM_BUILD_ROOT install-world

%if %plpython3

	mv src/Makefile.global src/Makefile.global.save

	cp src/Makefile.global.python3 src/Makefile.global

	touch -r src/Makefile.global.save src/Makefile.global

	pushd src/pl/plpython3

	make DESTDIR=$RPM_BUILD_ROOT install

	popd

	mv -f src/Makefile.global.save src/Makefile.global

%endif

# make sure these directories exist even if we suppressed all contrib modules

install -d -m 755 $RPM_BUILD_ROOT%{_datadir}/pgsql/contrib

install -d -m 755 $RPM_BUILD_ROOT%{_datadir}/pgsql/extension

# multilib header hack; note pg_config.h is installed in two places!

# we only apply this to known Red Hat multilib arches, per bug #177564

case `uname -i` in

  i386 | x86_64 | ppc | ppc64 | ppc64p7 | s390 | s390x | sparc | sparc64 | aarch64 )

    mv $RPM_BUILD_ROOT%{_includedir}/pg_config.h $RPM_BUILD_ROOT%{_includedir}/pg_config_`uname -i`.h

    install -m 644 %{SOURCE6} $RPM_BUILD_ROOT%{_includedir}/

    mv $RPM_BUILD_ROOT%{_includedir}/pgsql/server/pg_config.h $RPM_BUILD_ROOT%{_includedir}/pgsql/server/pg_config_`uname -i`.h

    install -m 644 %{SOURCE6} $RPM_BUILD_ROOT%{_includedir}/pgsql/server/

    mv $RPM_BUILD_ROOT%{_includedir}/ecpg_config.h $RPM_BUILD_ROOT%{_includedir}/ecpg_config_`uname -i`.h

    install -m 644 %{SOURCE7} $RPM_BUILD_ROOT%{_includedir}/

    ;;

  *)

    ;;

esac

install -d -m 755 $RPM_BUILD_ROOT%{_libdir}/pgsql/tutorial

cp -p src/tutorial/* $RPM_BUILD_ROOT%{_libdir}/pgsql/tutorial

%if ! %{selinux}

mkdir -p -m 755 $RPM_BUILD_ROOT%{_datadir}/pgsql/contrib

%endif

%if %pam

install -d $RPM_BUILD_ROOT/etc/pam.d

install -m 644 %{SOURCE14} $RPM_BUILD_ROOT/etc/pam.d/%{?scl_prefix}postgresql

%endif

# Create the directory for sockets.

install -d -m 755 $RPM_BUILD_ROOT%{?_localstatedir}/run/postgresql

# ... and make a tmpfiles script to recreate it at reboot.

mkdir -p $RPM_BUILD_ROOT%{_tmpfilesdir}

install -m 0644 %{SOURCE13} $RPM_BUILD_ROOT%{_tmpfilesdir}/%{?scl_prefix}postgresql.conf

# PGDATA needs removal of group and world permissions due to pg_pwd hole.

install -d -m 700 $RPM_BUILD_ROOT%{?_localstatedir}/lib/pgsql/data 

%if 0%{?scl:1}

rm -r $RPM_BUILD_ROOT/%{macrosdir}/macros.postgresql

%endif

# backups of data go here...

install -d -m 700 $RPM_BUILD_ROOT%{?_localstatedir}/lib/pgsql/backups

# postgres' .bash_profile

%if 0%{?scl:1}

install -d -m 755 $RPM_BUILD_ROOT%{?_root_localstatedir}/run/postgresql

# make sure /var/lib/pgsql exists, see bz#1023113

mkdir -p -m 700 $RPM_BUILD_ROOT%{?_localstatedir}/lib/pgsql

mkdir -p -m 700 $RPM_BUILD_ROOT%{?_root_localstatedir}/lib/pgsql

%endif

# see bz#1009365

sed -i	-e 's|/var/lib/pgsql/data|%{?localstatedir}/lib/pgsql/data|' postgresql-bashprofile

install -m 644 postgresql-bashprofile $RPM_BUILD_ROOT%{?_localstatedir}/lib/pgsql/.bash_profile

%if %test

	# tests. There are many files included here that are unnecessary,