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

%{!?beta:%global beta 0}

%{!?test:%global test 1}

%{!?upgrade:%global upgrade 1}

%{!?plpython:%global plpython 0}

%{!?plpython3:%global plpython3 1}

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

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

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

Summary: PostgreSQL client programs

Name: postgresql

%global majorversion 10

Version: %{majorversion}.17

Release: 3%{?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/

# This SRPM includes a copy of the previous major release, which is needed for

# in-place upgrade of an old database.  In most cases it will not be critical

# that this be kept up with the latest minor release of the previous series;

# but update when bugs affecting pg_dump output are fixed.

%global prevversion 9.2.24

%global prevmajorversion 9.2

%global prev_prefix %{_libdir}/pgsql/postgresql-%{prevmajorversion}

%global precise_version %{?epoch:%epoch:}%version-%release

%global setup_version 8.2

%global service_name 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

Source3: https://ftp.postgresql.org/pub/source/v%{prevversion}/postgresql-%{prevversion}.tar.bz2

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

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

# Comments for these patches are in the patch files.

Patch1: rpm-pgsql.patch

Patch2: postgresql-logging.patch

Patch5: postgresql-var-run-socket.patch

Patch6: postgresql-man.patch

Patch8: postgresql-no-libs.patch

Patch9: postgresql-server-pg_config.patch

Patch10: postgresql-10.15-contrib-dblink-expected-out.patch

BuildRequires: gcc

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 systemd-devel util-linux

BuildRequires: multilib-rpm-config

BuildRequires: libpq-devel

# 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

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

%global __provides_exclude_from %{_libdir}/pgsql

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

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

Group: Applications/Databases

Requires: %{name}%{?_isa} = %precise_version

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

%{?systemd_requires}

# Packages which provide postgresql plugins should build-require

# postgresql-server-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

%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} = %precise_version

# Just for more intuitive documentation installation

Provides: %{name}-doc = %precise_version

%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} = %precise_version

%description contrib

The postgresql-contrib package contains various extension modules that are

included in the PostgreSQL distribution.

%package server-devel

Summary: PostgreSQL development header files and libraries

Group: Development/Libraries

%description server-devel

The postgresql-server-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 test-rpm-macros

Summary: Convenience RPM macros for build-time testing against PostgreSQL server

Requires: %{name}-server = %precise_version

%description test-rpm-macros

This package is meant to be added as BuildRequires: dependency of other packages

that want to run build-time testsuite against running PostgreSQL server.

%package static

Summary: Statically linked PostgreSQL libraries

Requires: %{name}-server-devel%{?_isa} = %precise_version

%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} = %precise_version

Provides: bundled(postgresql-libs) = %prevversion

%description upgrade

The postgresql-upgrade package contains the pg_upgrade utility and supporting

files needed for upgrading a PostgreSQL database from the previous major

version of PostgreSQL.

%package upgrade-devel

Summary: Support for build of extensions required for upgrade process

Group: Development/Libraries

Requires: %{name}-upgrade%{?_isa} = %precise_version

%description upgrade-devel

The postgresql-devel package contains the header files and libraries

needed to compile C or C++ applications which are necessary in upgrade

process.

%endif

%if %plperl

%package plperl

Summary: The Perl procedural language for PostgreSQL

Group: Applications/Databases

Requires: %{name}-server%{?_isa} = %precise_version

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

%if %runselftest

BuildRequires: perl(Data::Dumper)

%endif

%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} = %precise_version

Provides: %{name}-plpython2 = %precise_version

%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} = %precise_version

%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} = %precise_version

%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} = %precise_version

Requires: %{name}-server-devel%{?_isa} = %precise_version

%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

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

%setup -q -a 12

%patch1 -p1

%patch2 -p1

%patch5 -p1

%patch6 -p1

%patch8 -p1

%patch9 -p1

%patch10 -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} .

%if %upgrade

tar xfj %{SOURCE3}

# apply once SOURCE3 is extracted

%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

cd postgresql-setup-%{setup_version}

%configure \

    pgdocdir=%{_pkgdocdir} \

    PGVERSION=%{version} \

    PGMAJORVERSION=%{majorversion} \

    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=%_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=%_datadir/zoneinfo

	--datadir=%_datadir/pgsql

	--with-systemd

'

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

make %{?_smp_mflags} -C src/pl/plpython all

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

cp -a src/pl/plpython src/pl/plpython3

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

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

make distclean

%endif # %%plpython3

PYTHON=/usr/bin/python2

# Normal (python2) build begins here

%configure $common_configure_options \

%if %plpython

	--with-python

%endif

unset PYTHON

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

	# 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

%if %upgrade

	pushd postgresql-%{prevversion}

	# The upgrade build can be pretty stripped-down, but make sure that

	# any options that affect on-disk file layout match the previous

	# major release!

	# The set of built server modules here should ideally create superset

	# of modules we used to ship in %%prevversion (in the installation

	# the user will upgrade from), including *-contrib or *-pl*

	# subpackages.  This increases chances that the upgrade from

	# %%prevversion will work smoothly.

upgrade_configure ()

{

	# Note we intentionally do not use %%configure here, because we *don't* want

	# its ideas about installation paths.

	# The -fno-aggressive-loop-optimizations is hack for #993532

	PYTHON="${PYTHON-/usr/bin/python2}" \

	CFLAGS="$CFLAGS -fno-aggressive-loop-optimizations" ./configure \

		--build=%{_build} \

		--host=%{_host} \

		--prefix=%prev_prefix \

		--disable-rpath \

%if %beta

		--enable-debug \

		--enable-cassert \

%endif

%if %plperl

		--with-perl \

%endif

%if %pltcl

		--with-tcl \

%endif

%if %ssl

	    --with-openssl \

%endif

		--with-tclconfig=%_libdir \

		--with-system-tzdata=/usr/share/zoneinfo \

		"$@"

}

%if %plpython3

	export PYTHON=/usr/bin/python3

	upgrade_configure --with-python

	# upstream fixed this later 7107d58ec5a3c45967e77525809612a5f89b97f3

	make %{?_smp_mflags} -C src/backend submake-errcodes

	make %{?_smp_mflags} -C src/pl/plpython all

	# save aside the only one file which we are interested here

	cp src/pl/plpython/plpython3.so ./

	unset PYTHON

	make distclean

%endif

	upgrade_configure \

%if %plpython

		--with-python

%endif

	make %{?_smp_mflags} all

	make -C contrib %{?_smp_mflags} all

	popd

%endif # %%upgrade

%install

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

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

id              postgresql

major           %{prevmajorversion}

data_default    %{_localstatedir}/pgsql/data

package         postgresql-upgrade

engine          %{_libdir}/pgsql/postgresql-%{prevmajorversion}/bin

description     "Upgrade data from system PostgreSQL version (PostgreSQL %{prevmajorversion})"

redhat_sockets_hack no

EOF

make DESTDIR=$RPM_BUILD_ROOT install-world

# We ship pg_config through libpq-devel

mv $RPM_BUILD_ROOT/%_mandir/man1/pg_{,server_}config.1

rm $RPM_BUILD_ROOT/%_includedir/pg_config*.h

rm $RPM_BUILD_ROOT/%_includedir/libpq/libpq-fs.h

rm $RPM_BUILD_ROOT/%_includedir/postgres_ext.h

rm -r $RPM_BUILD_ROOT/%_includedir/pgsql/internal/

%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

for header in \

	%{_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/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 %{SOURCE9} $RPM_BUILD_ROOT%{_tmpfilesdir}/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

# backups of data go here...

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

# postgres' .bash_profile

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

rm $RPM_BUILD_ROOT/%{_datadir}/man/man1/ecpg.1

%if %upgrade

	pushd postgresql-%{prevversion}

	make DESTDIR=$RPM_BUILD_ROOT install

	make -C contrib DESTDIR=$RPM_BUILD_ROOT install

%if %plpython3

	install -m 755 plpython3.so \

		$RPM_BUILD_ROOT/%_libdir/pgsql/postgresql-%prevmajorversion/lib

%endif

	popd

	# remove stuff we don't actually need for upgrade purposes