# This is the PostgreSQL Global Development Group Official RPMset spec file, # or a derivative thereof. # Copyright 2003-2009 Lamar Owen # and others listed. ** vi: ts=4 sw=4 noexpandtab nosmarttab # Major Contributors: # --------------- # Lamar Owen # Trond Eivind Glomsrd # 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 1} %{!?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 16 Version: %{majorversion}.4 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 15 %global prevversion %{prevmajorversion}.5 %global prev_prefix %{_libdir}/pgsql/postgresql-%{prevmajorversion} %global precise_version %{?epoch:%epoch:}%version-%release %global setup_version 8.9 %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 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 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 %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 < $RPM_BUILD_ROOT%macrosdir/macros.%name-upgrade %%postgresql_upgrade_prefix %prev_prefix EOF %endif # Let plugins use the same llvmjit settings as server has cat <> $RPM_BUILD_ROOT%macrosdir/macros.%name %%postgresql_server_llvmjit %llvmjit EOF %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 # pg_regress binary should be only in one subpackage, # there will be a symlink from -test to -devel rm -f $RPM_BUILD_ROOT%{_libdir}/pgsql/test/regress/pg_regress ln -sf ../../pgxs/src/test/regress/pg_regress $RPM_BUILD_ROOT%{_libdir}/pgsql/test/regress/pg_regress pushd $RPM_BUILD_ROOT%{_libdir}/pgsql/test/regress rm -f GNUmakefile Makefile *.o chmod 0755 pg_regress regress.so popd sed 's|@bindir@|%{_bindir}|g' \ < %{SOURCE4} \ > $RPM_BUILD_ROOT%{_libdir}/pgsql/test/regress/Makefile chmod 0644 $RPM_BUILD_ROOT%{_libdir}/pgsql/test/regress/Makefile %endif rm -rf doc/html # HACK! allow 'rpmbuild -bi --short-circuit' mv $RPM_BUILD_ROOT%{_docdir}/pgsql/html doc rm -rf $RPM_BUILD_ROOT%{_docdir}/pgsql # remove files not to be packaged rm $RPM_BUILD_ROOT%{_libdir}/libpgfeutils.a %if !%plperl rm -f $RPM_BUILD_ROOT%{_bindir}/pgsql/hstore_plperl.so %endif # no python2, yet installed, remove rm -f $RPM_BUILD_ROOT%{_datadir}/pgsql/extension/*_plpythonu* rm -f $RPM_BUILD_ROOT%{_datadir}/pgsql/extension/*_plpython2u* %if %nls find_lang_bins () { lstfile=$1 ; shift cp /dev/null "$lstfile" for binary; do %find_lang "$binary"-%{majorversion} cat "$binary"-%{majorversion}.lang >>"$lstfile" done } find_lang_bins devel.lst pg_server_config find_lang_bins server.lst \ initdb pg_basebackup pg_controldata pg_ctl pg_resetwal pg_rewind plpgsql \ postgres pg_checksums pg_verifybackup find_lang_bins contrib.lst \ pg_amcheck pg_archivecleanup pg_test_fsync pg_test_timing pg_waldump find_lang_bins main.lst \ pg_dump pg_upgrade pgscripts psql \ %if ! %external_libpq libpq%{private_soname}-5 %endif %if %plperl find_lang_bins plperl.lst plperl %endif %if %plpython3 find_lang_bins plpython3.lst plpython %endif %if %pltcl find_lang_bins pltcl.lst pltcl %endif %endif %pre server /usr/sbin/groupadd -g 26 -o -r postgres >/dev/null 2>&1 || : /usr/sbin/useradd -M -N -g postgres -o -r -d /var/lib/pgsql -s /bin/bash \ -c "PostgreSQL Server" -u 26 postgres >/dev/null 2>&1 || : %post server %systemd_post %service_name %preun server %systemd_preun %service_name %postun server %systemd_postun_with_restart %service_name %check %if %runselftest make -C postgresql-setup-%{setup_version} check %endif # FILES sections. %files -f main.lst %doc doc/KNOWN_BUGS doc/MISSING_FEATURES doc/TODO %doc COPYRIGHT README HISTORY %doc README.rpm-dist %{_bindir}/clusterdb %{_bindir}/createdb %{_bindir}/createuser %{_bindir}/dropdb %{_bindir}/dropuser %{_bindir}/pg_dump %{_bindir}/pg_dumpall %{_bindir}/pg_isready %{_bindir}/pg_restore %{_bindir}/pg_upgrade %{_bindir}/psql %{_bindir}/reindexdb %{_bindir}/vacuumdb %{_mandir}/man1/clusterdb.* %{_mandir}/man1/createdb.* %{_mandir}/man1/createuser.* %{_mandir}/man1/dropdb.* %{_mandir}/man1/dropuser.* %{_mandir}/man1/pg_dump.* %{_mandir}/man1/pg_dumpall.* %{_mandir}/man1/pg_isready.* %{_mandir}/man1/pg_restore.* %{_mandir}/man1/pg_upgrade.* %{_mandir}/man1/psql.* %{_mandir}/man1/reindexdb.* %{_mandir}/man1/vacuumdb.* %{_mandir}/man7/* %if %llvmjit # Install bitcode directory along with the main package, # so that extensions can use this dir. %dir %{_libdir}/pgsql/bitcode %endif %if ! %external_libpq %files private-libs %{_libdir}/libpq.so.* %endif %files docs %doc doc/html %{_libdir}/pgsql/tutorial/ %files contrib -f contrib.lst %doc contrib/spi/*.example %{_bindir}/oid2name %{_bindir}/pg_amcheck %{_bindir}/pg_archivecleanup %{_bindir}/pg_test_fsync %{_bindir}/pg_test_timing %{_bindir}/pg_waldump %{_bindir}/pgbench %{_bindir}/vacuumlo %{_datadir}/pgsql/extension/adminpack* %{_datadir}/pgsql/extension/amcheck* %{_datadir}/pgsql/extension/autoinc* %{_datadir}/pgsql/extension/bloom* %{_datadir}/pgsql/extension/btree_gin* %{_datadir}/pgsql/extension/btree_gist* %{_datadir}/pgsql/extension/citext* %{_datadir}/pgsql/extension/cube* %{_datadir}/pgsql/extension/dblink* %{_datadir}/pgsql/extension/dict_int* %{_datadir}/pgsql/extension/dict_xsyn* %{_datadir}/pgsql/extension/earthdistance* %{_datadir}/pgsql/extension/file_fdw* %{_datadir}/pgsql/extension/fuzzystrmatch* %{_datadir}/pgsql/extension/hstore* %{_datadir}/pgsql/extension/insert_username* %{_datadir}/pgsql/extension/intagg* %{_datadir}/pgsql/extension/intarray* %{_datadir}/pgsql/extension/isn* %if %{plperl} %{_datadir}/pgsql/extension/jsonb_plperl* %endif %if %{plpython3} %{_datadir}/pgsql/extension/jsonb_plpython3u* %endif %{_datadir}/pgsql/extension/lo* %{_datadir}/pgsql/extension/ltree* %{_datadir}/pgsql/extension/moddatetime* %{_datadir}/pgsql/extension/old_snapshot* %{_datadir}/pgsql/extension/pg_surgery* %{_datadir}/pgsql/extension/pageinspect* %{_datadir}/pgsql/extension/pg_buffercache* %{_datadir}/pgsql/extension/pg_freespacemap* %{_datadir}/pgsql/extension/pg_prewarm* %{_datadir}/pgsql/extension/pg_stat_statements* %{_datadir}/pgsql/extension/pg_trgm* %{_datadir}/pgsql/extension/pg_visibility* %{_datadir}/pgsql/extension/pgcrypto* %{_datadir}/pgsql/extension/pgrowlocks* %{_datadir}/pgsql/extension/pgstattuple* %{_datadir}/pgsql/extension/postgres_fdw* %{_datadir}/pgsql/extension/refint* %{_datadir}/pgsql/extension/seg* %{_datadir}/pgsql/extension/tablefunc* %{_datadir}/pgsql/extension/tcn* %{_datadir}/pgsql/extension/tsm_system_rows* %{_datadir}/pgsql/extension/tsm_system_time* %{_datadir}/pgsql/extension/unaccent* %{_datadir}/pgsql/extension/pg_walinspect* %{_libdir}/pgsql/_int.so %{_libdir}/pgsql/adminpack.so %{_libdir}/pgsql/amcheck.so %{_libdir}/pgsql/auth_delay.so %{_libdir}/pgsql/auto_explain.so %{_libdir}/pgsql/autoinc.so %{_libdir}/pgsql/bloom.so %{_libdir}/pgsql/btree_gin.so %{_libdir}/pgsql/btree_gist.so %{_libdir}/pgsql/citext.so %{_libdir}/pgsql/cube.so %{_libdir}/pgsql/dblink.so %{_libdir}/pgsql/dict_int.so %{_libdir}/pgsql/dict_xsyn.so %{_libdir}/pgsql/earthdistance.so %{_libdir}/pgsql/file_fdw.so %{_libdir}/pgsql/fuzzystrmatch.so %{_libdir}/pgsql/hstore.so %if %plperl %{_libdir}/pgsql/hstore_plperl.so %endif %if %plpython3 %{_libdir}/pgsql/hstore_plpython3.so %endif %{_libdir}/pgsql/insert_username.so %{_libdir}/pgsql/isn.so %if %plperl %{_libdir}/pgsql/jsonb_plperl.so %endif %if %plpython3 %{_libdir}/pgsql/jsonb_plpython3.so %endif %{_libdir}/pgsql/lo.so %{_libdir}/pgsql/ltree.so %if %plpython3 %{_libdir}/pgsql/ltree_plpython3.so %endif %{_libdir}/pgsql/moddatetime.so %{_libdir}/pgsql/old_snapshot.so %{_libdir}/pgsql/pg_surgery.so %{_libdir}/pgsql/pageinspect.so %{_libdir}/pgsql/passwordcheck.so %{_libdir}/pgsql/pg_buffercache.so %{_libdir}/pgsql/pg_freespacemap.so %{_libdir}/pgsql/pg_stat_statements.so %{_libdir}/pgsql/pg_trgm.so %{_libdir}/pgsql/pg_visibility.so %{_libdir}/pgsql/pgcrypto.so %{_libdir}/pgsql/pgrowlocks.so %{_libdir}/pgsql/pgstattuple.so %{_libdir}/pgsql/postgres_fdw.so %{_libdir}/pgsql/refint.so %{_libdir}/pgsql/seg.so %{_libdir}/pgsql/tablefunc.so %{_libdir}/pgsql/tcn.so %{_libdir}/pgsql/test_decoding.so %{_libdir}/pgsql/tsm_system_rows.so %{_libdir}/pgsql/tsm_system_time.so %{_libdir}/pgsql/unaccent.so %{_libdir}/pgsql/basebackup_to_shell.so %{_libdir}/pgsql/basic_archive.so %{_libdir}/pgsql/pg_walinspect.so %{_mandir}/man1/oid2name.* %{_mandir}/man1/pg_amcheck.* %{_mandir}/man1/pg_archivecleanup.* %{_mandir}/man1/pg_recvlogical.* %{_mandir}/man1/pg_test_fsync.* %{_mandir}/man1/pg_test_timing.* %{_mandir}/man1/pg_waldump.* %{_mandir}/man1/pgbench.* %{_mandir}/man1/vacuumlo.* %{_mandir}/man3/dblink* %if %selinux %{_datadir}/pgsql/contrib/sepgsql.sql %{_libdir}/pgsql/sepgsql.so %endif %if %ssl %{_datadir}/pgsql/extension/sslinfo* %{_libdir}/pgsql/sslinfo.so %endif %if %uuid %{_datadir}/pgsql/extension/uuid-ossp* %{_libdir}/pgsql/uuid-ossp.so %endif %if %xml %{_datadir}/pgsql/extension/xml2* %{_libdir}/pgsql/pgxml.so %endif %files server -f server.lst %{_bindir}/initdb %{_bindir}/pg_basebackup %{_bindir}/pg_controldata %{_bindir}/pg_ctl %{_bindir}/pg_receivewal %{_bindir}/pg_recvlogical %{_bindir}/pg_resetwal %{_bindir}/pg_rewind %{_bindir}/pg_checksums %{_bindir}/pg_verifybackup %{_bindir}/postgres %{_bindir}/postgresql-setup %{_bindir}/postgresql-upgrade %dir %{_datadir}/pgsql %{_datadir}/pgsql/*.sample %dir %{_datadir}/pgsql/contrib %dir %{_datadir}/pgsql/extension %{_datadir}/pgsql/extension/plpgsql* %{_datadir}/pgsql/information_schema.sql %{_datadir}/pgsql/postgres.bki %{_datadir}/pgsql/snowball_create.sql %{_datadir}/pgsql/sql_features.txt %{_datadir}/pgsql/system_constraints.sql %{_datadir}/pgsql/system_functions.sql %{_datadir}/pgsql/system_views.sql %{_datadir}/pgsql/fix-CVE-2024-4317.sql %{_datadir}/pgsql/timezonesets/ %{_datadir}/pgsql/tsearch_data/ %dir %{_datadir}/postgresql-setup %{_datadir}/postgresql-setup/library.sh %dir %{_libdir}/pgsql %{_libdir}/pgsql/*_and_*.so %{_libdir}/pgsql/dict_snowball.so %{_libdir}/pgsql/euc2004_sjis2004.so %{_libdir}/pgsql/libpqwalreceiver.so %{_libdir}/pgsql/pg_prewarm.so %{_libdir}/pgsql/pgoutput.so %{_libdir}/pgsql/plpgsql.so %dir %{_libexecdir}/initscripts/legacy-actions/postgresql %{_libexecdir}/initscripts/legacy-actions/postgresql/* %{_libexecdir}/postgresql-check-db-dir %dir %{_sysconfdir}/postgresql-setup %dir %{_sysconfdir}/postgresql-setup/upgrade %config %{_sysconfdir}/postgresql-setup/upgrade/*.conf %{_mandir}/man1/initdb.* %{_mandir}/man1/pg_basebackup.* %{_mandir}/man1/pg_controldata.* %{_mandir}/man1/pg_ctl.* %{_mandir}/man1/pg_receivewal.* %{_mandir}/man1/pg_resetwal.* %{_mandir}/man1/pg_rewind.* %{_mandir}/man1/pg_checksums.* %{_mandir}/man1/pg_verifybackup.* %{_mandir}/man1/postgres.* %{_mandir}/man1/postgresql-new-systemd-unit.* %{_mandir}/man1/postgresql-setup.* %{_mandir}/man1/postgresql-upgrade.* %{_sbindir}/postgresql-new-systemd-unit %{_tmpfilesdir}/postgresql.conf %{_unitdir}/*postgresql*.service %attr(700,postgres,postgres) %dir %{?_localstatedir}/lib/pgsql %attr(644,postgres,postgres) %config(noreplace) %{?_localstatedir}/lib/pgsql/.bash_profile %attr(700,postgres,postgres) %dir %{?_localstatedir}/lib/pgsql/backups %attr(700,postgres,postgres) %dir %{?_localstatedir}/lib/pgsql/data %attr(755,postgres,postgres) %dir %{?_localstatedir}/run/postgresql %if %pam %config(noreplace) /etc/pam.d/postgresql %endif %files server-devel -f devel.lst %{_bindir}/pg_server_config %dir %{_datadir}/pgsql %{_datadir}/pgsql/errcodes.txt %dir %{_includedir}/pgsql %{_includedir}/pgsql/server %{_libdir}/pgsql/pgxs/ %{_mandir}/man1/pg_server_config.* %{_mandir}/man3/SPI_* %{macrosdir}/macros.%name %if ! %external_libpq %files private-devel %{_bindir}/pg_config %{_includedir}/libpq-events.h %{_includedir}/libpq-fe.h %{_includedir}/postgres_ext.h %{_includedir}/pgsql/internal/*.h %{_includedir}/pgsql/internal/libpq/pqcomm.h %{_includedir}/libpq/*.h %exclude %{_libdir}/pkgconfig/*.pc %{_libdir}/libpq.so %{_includedir}/pg_config*.h %endif %files test-rpm-macros %{_datadir}/postgresql-setup/postgresql_pkg_tests.sh %{macrosdir}/macros.%name-test %files static %{_libdir}/libpgcommon.a %{_libdir}/libpgport.a %{_libdir}/libpgcommon_shlib.a %{_libdir}/libpgport_shlib.a %if %upgrade %files upgrade %{_libdir}/pgsql/postgresql-%{prevmajorversion}/bin %exclude %{_libdir}/pgsql/postgresql-%{prevmajorversion}/bin/pg_config %{_libdir}/pgsql/postgresql-%{prevmajorversion}/lib %exclude %{_libdir}/pgsql/postgresql-%{prevmajorversion}/lib/pgxs %exclude %{_libdir}/pgsql/postgresql-%{prevmajorversion}/lib/pkgconfig %{_libdir}/pgsql/postgresql-%{prevmajorversion}/share %files upgrade-devel %{_libdir}/pgsql/postgresql-%{prevmajorversion}/bin/pg_config %{_libdir}/pgsql/postgresql-%{prevmajorversion}/include %{_libdir}/pgsql/postgresql-%{prevmajorversion}/lib/pkgconfig %{_libdir}/pgsql/postgresql-%{prevmajorversion}/lib/pgxs %{macrosdir}/macros.%name-upgrade %endif %if %llvmjit %files llvmjit %defattr(-,root,root) %{_libdir}/pgsql/bitcode/* %{_libdir}/pgsql/llvmjit.so %{_libdir}/pgsql/llvmjit_types.bc %endif %if %plperl %files plperl -f plperl.lst %{_datadir}/pgsql/extension/bool_plperl* %{_datadir}/pgsql/extension/plperl* %{_libdir}/pgsql/bool_plperl.so %{_libdir}/pgsql/plperl.so %endif %if %pltcl %files pltcl -f pltcl.lst %{_datadir}/pgsql/extension/pltcl* %{_libdir}/pgsql/pltcl.so %endif %if %plpython3 %files plpython3 -f plpython3.lst %{_datadir}/pgsql/extension/plpython3* %{_libdir}/pgsql/plpython3.so %endif %if %test %files test %attr(-,postgres,postgres) %{_libdir}/pgsql/test %endif %changelog * Mon Jan 08 2024 Filip Janus - 16.1-1 - Update to 16.1 - Update upgrade server to 15.5 - Resolves: RHEL-3636 * Mon Oct 09 2023 Filip Janus - 16.0-1 - New postgresql stream - 16 - Remove pdf documentation - Update postgresql-setup to 8.9 - postmaster binary no more shipped - Resolves: RHEL-3636 * Wed Aug 02 2023 Jorge San Emeterio - 15.3-1 - Update to upstream version 15.3 - Fixes: CVE-2023-2454 CVE-2023-2455 - Resolves: #2207934 * Wed Feb 08 2023 Filip Januš - 15.2-1 - Update to upstream version 15.2 - Update postgresql-setup to 8.8 - PostgreSQL systemd unit waits for the network to be up - Resolves: #2128241 * Fri Oct 14 2022 Filip Januš - 15.0-1 - Initial import for postgresql 15 - Specfile is based on version locate in centos stream It reflects changes with libpq. This version of databse server will use private libpq library. - Resolves: #2128241