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

# Disable temporarily to be able to build the package

# tracked in RHBZ#1940964

%{!?llvmjit:%global llvmjit 0}

%{!?external_libpq:%global external_libpq 0}

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

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

Version: %{majorversion}.7

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

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

%global prevversion %{prevmajorversion}.11

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

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

%global setup_version 8.6

%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

Patch8: postgresql-external-libpq.patch

Patch9: postgresql-server-pg_config.patch

Patch12: postgresql-no-libecpg.patch

Patch14: postgresql-pgcrypto-openssl3-tests.patch

BuildRequires: make

BuildRequires: gcc

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

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

BuildRequires: perl(Opcode)

%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

%if %external_libpq

BuildRequires: libpq-devel >= %version

%endif

BuildRequires: docbook-style-xsl

# postgresql-setup build requires

BuildRequires: m4 elinks docbook-utils help2man

%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

%if %icu

BuildRequires:	libicu-devel

%endif

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

# and do not provide pkgconfig RPM provides (RHBZ#1980992)

%global __provides_exclude_from %{_libdir}/(pgsql|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.

%if ! %external_libpq

%package private-libs

Summary: The shared libraries required only for this build of PostgreSQL server

Group: Applications/Databases

# for /sbin/ldconfig

Requires(post): glibc

Requires(postun): glibc

%description private-libs

The postgresql-private-libs package provides the shared libraries for this

build of PostgreSQL server and plugins build with this version of server.

For shared libraries used by client packages that need to connect to a

PostgreSQL server, install libpq package instead.

%package private-devel

Summary: PostgreSQL development header files for this build of PostgreSQL server

Group: Development/Libraries

Requires: %{name}-private-libs%{?_isa} = %precise_version

# Conflict is desired here, a user must pick one or another

Conflicts: libpq-devel

%description private-devel

The postgresql-private-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.

You need to install this package if you want to develop applications which

will interact with a PostgreSQL server.

%endif

%package server

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

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

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

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

%if %icu

Requires:	libicu-devel

%endif

%if %kerberos

Requires: krb5-devel

%endif

%if %llvmjit

Requires: clang-devel llvm-devel

%endif

%if %external_libpq

# Some extensions require libpq

# Do not make them care about whether server uses private or system-wide

# libpq, simply let the server pull the correct one

Requires: libpq-devel

%else

Requires: %{name}-private-devel

%endif

%description server-devel

The postgresql-server-devel package contains the header files and configuration

needed to compile PostgreSQL server extension.

%package test-rpm-macros

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

Requires: %{name}-server = %precise_version

BuildArch: noarch

%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

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

Provides: bundled(postgresql-server) = %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

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

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

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

%if %runselftest

BuildRequires: perl(Opcode)

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

%package plpython3

Summary: The Python3 procedural language for PostgreSQL

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

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

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

%if %llvmjit

%package llvmjit

Summary:	Just-in-time compilation support for PostgreSQL

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

%if 0%{?rhel} && 0%{?rhel} == 7

Requires:	llvm5.0 >= 5.0

%else

Requires:	llvm => 5.0

%endif

Provides:	postgresql-llvmjit >= %{version}-%{release}

BuildRequires:	llvm-devel >= 5.0 clang-devel >= 5.0

%description llvmjit

The postgresql-llvmjit package contains support for

just-in-time compiling parts of PostgreSQL queries. Using LLVM it

compiles e.g. expressions and tuple deforming into native code, with the

goal of accelerating analytics queries.

%endif

%prep

(

  cd "$(dirname "%{SOURCE0}")"

  sha256sum -c %{SOURCE16}

%if %upgrade

  sha256sum -c %{SOURCE17}

%endif

)

%setup -q -a 12 -n postgresql-%{version}

%patch1 -p1

%patch2 -p1

%patch5 -p1

%if %external_libpq

%patch8 -p1

%else

%patch12 -p1

%endif

%patch9 -p1

%patch14 -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 ! %external_libpq

%global private_soname private%{majorversion}

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

%endif

%if %upgrade

tar xfj %{SOURCE3}

# libpq from this upgrade-only build is dropped and the libpq from the main

# version is used. Use the same major hack therefore.

%if ! %external_libpq

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

%endif

# 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

# Avoid LTO on armv7hl as it runs out of memory

%ifarch armv7hl s390x

%define _lto_cflags %{nil}

%endif

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

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

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

export CFLAGS

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

	--with-icu

%endif

%if %llvmjit

	--with-llvm

%endif

%if %plpython3

	--with-python

%endif

'

export PYTHON=/usr/bin/python3

# These configure options must match main build

%configure $common_configure_options

%make_build 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"

	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

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

		--build=%{_build} \

		--host=%{_host} \

		--prefix=%prev_prefix \

		--disable-rpath \

%if %beta

		--enable-debug \

		--enable-cassert \

%endif

%if %icu

		--with-icu \

%endif

%if %plperl

		--with-perl \

%endif

%if %pltcl

		--with-tcl \

%endif

%if %ssl

	    --with-openssl \

%endif

%if %plpython3

		--with-python \

%endif

		--with-tclconfig=%_libdir \

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

		"$@"

}

	upgrade_configure \

	make %{?_smp_mflags} all

	make -C contrib %{?_smp_mflags} all

	popd

# endif upgrade

%endif

%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

%if %external_libpq

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/

%else

ln -s pg_server_config $RPM_BUILD_ROOT/%_bindir/pg_config

rm $RPM_BUILD_ROOT/%{_libdir}/libpq.a

%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}/pg_config.h \

	%{_includedir}/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...