# 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.                 ** vi: ts=4 sw=4 noexpandtab nosmarttab

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

%global scl rh-postgresql13

%{?scl:%scl_package postgresql}

%{!?beta:%global beta 0}

%{!?test:%global test 1}

%{!?plpython:%global plpython 1}

%{!?plpython3:%global plpython3 1}

%{!?pltcl:%global pltcl 1}

%{!?plperl:%global plperl 1}

%{!?ssl:%global ssl 1}

%{!?icu:%global icu 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}

%{!?systemd_build:%global systemd_build 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

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

Version: %{majorversion}.13

Release: 1%{?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 8.5

%global service_name %{?scl_prefix}postgresql.service

Source0: https://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

Source4: Makefile.regress

Source9: postgresql.tmpfiles.d

Source10: postgresql.pam

Source11: postgresql-bashprofile

# git: https://github.com/devexp-db/postgresql-setup

Source12: https://github.com/devexp-db/postgresql-setup/releases/download/v%{setup_version}/postgresql-setup-%{setup_version}.tar.gz

# Those here are just to enforce packagers check that the tarball was downloaded

# correctly.  Also, this allows us check that packagers-only tarballs do not

# differ with publicly released ones.

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

# Comments for these patches are in the patch files.

Patch1: rpm-pgsql.patch

Patch2: postgresql-logging.patch

Patch3: postgresql-perl-rpath.patch

Patch5: postgresql-var-run-socket.patch

Patch6: postgresql-man.patch

Patch7: postgresql-socket-dirs-pgupgrade.patch

Patch8: postgresql-libpqwalreceiver-rpath.patch

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

BuildRequires: perl(ExtUtils::Embed), perl-devel

%if 0%{?fedora} || 0%{?rhel} > 7

BuildRequires: perl-generators

%endif

BuildRequires: readline-devel zlib-devel

BuildRequires: systemd-units systemd-devel

BuildRequires: util-linux

# We don't have to take care of multilib in SCL.

BuildRequires: multilib-rpm-config

# postgresql-setup build requires

BuildRequires: m4 elinks docbook-utils help2man

%if %plpython

BuildRequires: python2-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}

%if %icu

BuildRequires: libicu-devel

%endif

# Needed for:

# - RHEL7 lib* plugins

# - https://bugzilla.redhat.com/1464368 elsewhere

# Filtering: https://fedoraproject.org/wiki/Packaging:AutoProvidesAndRequiresFiltering

%global __provides_exclude_from ^%{_libdir}/(pgsql|pkgconfig)

%global __requires_exclude_from ^%{_libdir}/pkgconfig

%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

%{!?scl:Provides: libpq.so = %{version}-%{release}}

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

%{?scl:Requires: /usr/bin/scl_source}

Requires(pre): /usr/sbin/useradd

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

Requires: systemd-units

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

%{?systemd_requires}

# Packages which provide postgresql plugins should build-require

# postgresql-devel and require

# postgresql-server(:MODULE_COMPAT_%%{postgresql_major}).

# This will automatically guard against incompatible server & plugin

# installation (#1008939, #1007840)

Provides: %{name}-server(:MODULE_COMPAT_%{majorversion})

Provides: bundled(postgresql-setup) = %setup_version

%{?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}

# Just for more intuitive documentation installation

Provides: %{name}-doc = %{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}-libs%{?_isa} = %{version}-%{release}

%if %icu

Requires:      libicu-devel

%endif

%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 %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))

%if %runselftest

BuildRequires: perl(Data::Dumper)

%endif

%{?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

%if 0%{?scl:1}

%scl_syspaths_package -d

%scl_syspaths_package contrib -d

%scl_syspaths_package server -d

%endif

%prep

( cd %_sourcedir; sha256sum -c %{SOURCE16} )

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

%patch1 -p1

%patch2 -p1

%if 0%{?rhel:1} && 0%{?rhel} <= 7

%patch3 -p1

%endif

%patch5 -p1

%patch6 -p1

%patch7 -p1

%patch8 -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.

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.

%if 0%{?scl:1}

%global scl_sed_patches 1

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

%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

# Building postgresql-setup

%{?scl:scl enable %{scl} - << "EOFSCL"}

set -ex

cd postgresql-setup-%{setup_version}

%configure \

    pgdocdir=%{_pkgdocdir} \

    PGVERSION=%{version} \

    PGMAJORVERSION=%{majorversion} \

    %{?scl:--with-scl} \

    NAME_DEFAULT_PREV_SERVICE=postgresql

make %{?_smp_mflags}

cd ..

# Fiddling with CFLAGS.

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

%ifarch %{power64}

# See the bug #1051075, ppc64 should benefit from -O3

CFLAGS=`echo $CFLAGS | xargs -n 1 | sed 's|-O2|-O3|g' | xargs -n 100`

%endif

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

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

export CFLAGS

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

common_configure_options='

	--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 %ldap

	--with-ldap

%endif

%if %ssl

	--with-openssl

%endif

%if %pam

	--with-pam

%endif

%if %kerberos

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

	--with-systemd

%if %icu

       --with-icu

%endif

'

%if %plpython3

export PYTHON=/usr/bin/python3

# These configure options must match main build

%configure $common_configure_options \

	--with-python

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

%global python_subdirs       \\\

	src/pl/plpython          \\\

	contrib/hstore_plpython  \\\

	contrib/jsonb_plpython   \\\

	contrib/ltree_plpython

for dir in %python_subdirs; do

	%make_build -C "$dir" all

done

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

for dir in %python_subdirs; do

	rm -rf "${dir}3" # shouldn't exist, unless --short-circuit

	cp -a "$dir" "${dir}3"

done

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

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

make distclean

%endif # %%plpython3

unset PYTHON

# Normal (python2) build begins here

%configure $common_configure_options \

%if %plpython

	--with-python

%endif

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

# 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'.  This function

# never exits directly nor stops rpmbuild where `set -e` is enabled.

run_testsuite()

{

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

	(

		set +x

		echo "=== trying to find all regression.diffs files in build directory ==="

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

		while read line; do

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

			cat "$line"

		done

	)

}

test_failure=0

%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

	for dir in %python_subdirs; do

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

		# we must temporarily install *plpython3 dir as *plpython,

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

		mv "$dir" "${dir}2"

		mv "${dir}3" "$dir"

	done

	for dir in %python_subdirs; do

		run_testsuite "$dir"

	done

	for dir in %python_subdirs; do

		# and clean up our mess

		mv "$dir" "${dir}3"

		mv "${dir}2" "${dir}"

	done

	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

%{?scl:EOFSCL}

%install

%{?scl:scl enable %{scl} - << "EOFSCL"}

set -ex

cd postgresql-setup-%{setup_version}

make install DESTDIR=$RPM_BUILD_ROOT

cd ..

# For some reason, having '%%doc %%{_pkgdocdir}/README.rpm-dist' in %%files

# causes FTBFS (at least on RHEL6), see rhbz#1250006.

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

case "%{?rhel}" in

7) sys_pg_version=9.2 upgrade_hacks='redhat_sockets_hack yes' ;;

esac

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

id              postgresql

major           $sys_pg_version

data_default    /var/lib/pgsql/data

engine          /usr/bin

description     "Upgrade data from system PostgreSQL version (PostgreSQL $sys_pg_version)"

$upgrade_hacks

EOF

# gen_scl_upgrade_config VERSION PREFIXES

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

gen_scl_upgrade_config ()

{

	pver=$1

	for pfx in $2; do

		name=${pfx}postgresql${pver//./}

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

id              $name-postgresql

major           $pver

data_default    /var/opt/rh/$name/lib/pgsql/data

engine          /opt/rh/$name/root/usr/bin

description     "Upgrade data from RHSCL PostgreSQL version (PostgreSQL $pver)"

scls            "$name"

EOF

	done

}

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 PostgreSQL version (PostgreSQL 9.2)"

scls            "postgresql92"

redhat_sockets_hack yes

EOF

for version in 9.4 9.5 9.6 10 12; do

	gen_scl_upgrade_config "$version" "rh- sclo-"

done

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

	for dir in %python_subdirs; do

		%make_install -C "${dir}3"

	done

	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; some headers are installed in two places!

for header in \

	%{_includedir}/pg_config.h \

	%{_includedir}/pg_config_ext.h \

	%{_includedir}/ecpg_config.h \

	%{_includedir}/pgsql/server/pg_config.h \

	%{_includedir}/pgsql/server/pg_config_ext.h

do

%multilib_fix_c_header --file "$header"

done

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

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

%if %pam

install -d $RPM_BUILD_ROOT/etc/pam.d

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

%endif

# Create the directory for sockets.

install -d -m 755 $RPM_BUILD_ROOT%{?!scl:%_localstatedir}%{?scl:%_root_localstatedir}/run/postgresql

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

mkdir -p $RPM_BUILD_ROOT%{_tmpfilesdir}

install -m 0644 %{SOURCE9} $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}

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

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

%endif

# backups of data go here...

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

%if 0%{!?scl:1}

# postgres' .bash_profile

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

%endif

%if %test

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

	# but include them anyway for completeness.  We replace the original

	# Makefiles, however.

	mkdir -p $RPM_BUILD_ROOT%{_libdir}/pgsql/test

	cp -a src/test/regress $RPM_BUILD_ROOT%{_libdir}/pgsql/test