# # spec file for package postgresql12 # # Copyright (c) 2020 SUSE LLC # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed # upon. The license for this file, and modifications and additions to the # file, is the same license as for the pristine package itself (unless the # license for the pristine package is not an Open Source License, in which # case the license is the MIT License). An "Open Source License" is a # license that conforms to the Open Source Definition (Version 1.9) # published by the Open Source Initiative. # Please submit bugfixes or comments via https://bugs.opensuse.org/ # %define pgmajor 12 %define pgname postgresql%pgmajor %define priority %{pgmajor} %define libpq libpq5 %define libecpg libecpg6 %define libpq_so libpq.so.5 %define libecpg_so libecpg.so.6 %define pgbasedir %_prefix/lib/%pgname %define pgtestdir %pgbasedir/test %define pgbindir %pgbasedir/bin %define pglibdir %pgbasedir/%_lib %define pgincludedir %_includedir/pgsql %define pgdatadir %_datadir/%pgname %define pgdocdir %_docdir/%pgname %define pgextensiondir %pgdatadir/extension %define pgcontribdir %pgdatadir/contrib %define pgmandir %_mandir %if "@BUILD_FLAVOR@" == "libs" Name: %pgname-libs %define buildmain 0 %define buildlibs 1 %define builddevel 1 %else Name: %pgname %define buildmain 1 %define buildlibs 0 %define builddevel 0 %endif %if 0%{?suse_version} >= 1300 && %buildmain %bcond_without systemd %else %bcond_with systemd %endif %if 0%{?suse_version} >= 1500 && %buildmain %bcond_without systemd_notify %bcond_without llvm %else %bcond_with systemd_notify %bcond_with llvm %endif %if %buildmain %bcond_without selinux %bcond_without icu %else %bcond_with selinux %bcond_with icu %endif %ifnarch %arm %bcond_without check %else %bcond_with check %endif %if %buildmain BuildRequires: docbook_4 BuildRequires: gettext-devel BuildRequires: libuuid-devel BuildRequires: ncurses-devel BuildRequires: pam-devel BuildRequires: python3-devel BuildRequires: readline-devel BuildRequires: tcl-devel BuildRequires: timezone BuildRequires: zlib-devel # %endif BuildRequires: fdupes %if %{with icu} BuildRequires: libicu-devel %endif %if %{with selinux} BuildRequires: libselinux-devel %endif %if %{with llvm} BuildRequires: clang-devel BuildRequires: gcc-c++ BuildRequires: llvm-devel %endif BuildRequires: libxslt-devel BuildRequires: openldap2-devel BuildRequires: openssl-devel BuildRequires: pkg-config BuildRequires: pkgconfig(krb5) %if %{with systemd_notify} BuildRequires: pkgconfig(libsystemd) BuildRequires: pkgconfig(systemd) %endif #!BuildIgnore: %pgname #!BuildIgnore: %pgname-server #!BuildIgnore: postgresql-implementation #!BuildIgnore: postgresql-server-implementation Summary: Basic Clients and Utilities for PostgreSQL License: PostgreSQL Group: Productivity/Databases/Tools Version: 12.1 Release: 0 %define pkg_version 12.1 Source0: https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{pkg_version}.tar.bz2 Source1: https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{pkg_version}.tar.bz2.sha256 Source2: baselibs.conf Source3: postgresql-README.SUSE Source17: postgresql-rpmlintrc Source18: series Patch1: postgresql-conf.patch Patch2: postgresql-regress.patch # PL/Perl needs to be linked with rpath (bsc#578053) Patch4: postgresql-plperl-keep-rpath.patch Patch6: postgresql-testsuite-int8.sql.patch Patch8: postgresql-testsuite-keep-results-file.patch Patch9: postgresql-var-run-socket.patch URL: https://www.postgresql.org/ BuildRoot: %{_tmppath}/%{name}-%{version}-build Provides: postgresql = %version-%release Provides: postgresql-implementation = %version-%release Requires: %libpq >= %version Requires(post): postgresql-noarch >= %pgmajor Requires(postun): postgresql-noarch >= %pgmajor %description PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the basic utility and client programs necessary to maintain and work with local or remote PostgreSQL databases as well as manual pages for the SQL commands that PostgreSQL supports. Full HTML documentation for PostgreSQL can be found in the postgresql-docs package. %package -n %libpq Summary: Shared Libraries Required for PostgreSQL Clients Group: Productivity/Databases/Clients Provides: postgresql-libs:%_libdir/libpq.so.5 Obsoletes: postgresql-libs < %version # bug437293 %if "%_lib" == "lib64" Conflicts: %libpq-32bit < %version %endif %ifarch ia64 Conflicts: %libpq-x86 < %version %endif %ifarch ppc64 Obsoletes: postgresql-libs-64bit %endif %description -n %libpq PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions. This package provides the client library that most PostgreSQL client program or language bindings are using. %package -n %libecpg Summary: Shared Libraries Required for PostgreSQL Clients Group: Productivity/Databases/Clients Provides: postgresql-libs:%_libdir/libecpg.so.6 %description -n %libecpg PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions. This package provides the runtime library of the embedded SQL C preprocessor for PostgreSQL. %if %builddevel %package -n %pgname-devel Summary: PostgreSQL client development header files and libraries Group: Development/Libraries/C and C++ Provides: postgresql-devel-implementation = %version-%release Requires: %libecpg >= %version Requires: %libpq >= %version # Installation of postgresql??-devel is exclusive Provides: postgresql-devel-exclusive = %pgmajor Conflicts: postgresql-devel-exclusive < %pgmajor %description -n %pgname-devel PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the header files and libraries needed to compile C applications which will directly interact with a PostgreSQL database management server and the ECPG Embedded C Postgres preprocessor. You need to install this package if you want to develop applications in C which will interact with a PostgreSQL server. For building PostgreSQL server extensions, see the postgresql%pgmajor-server-devel package. %endif %if %buildmain %package server Summary: The Programs Needed to Create and Run a PostgreSQL Server Group: Productivity/Databases/Servers PreReq: /sbin/chkconfig PreReq: postgresql = %version Requires: glibc-locale Requires: timezone Recommends: %{name}-llvmjit Provides: postgresql-server-implementation = %version-%release Requires: %libpq >= %version Requires(pre): postgresql-server-noarch >= %pgmajor Requires(preun): postgresql-server-noarch >= %pgmajor Requires(postun): postgresql-server-noarch >= %pgmajor Requires(post): postgresql-noarch >= %pgmajor Requires(postun): postgresql-noarch >= %pgmajor %description server PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, sub-queries, triggers, and user-defined types and functions. This package includes the programs needed to create and run a PostgreSQL server, which will in turn allow you to create and maintain PostgreSQL databases. %package server-devel Summary: PostgreSQL server development header files and utilities Group: Development/Libraries/C and C++ Provides: postgresql-server-devel = %version-%release Provides: postgresql-server-devel-implementation = %version-%release Requires(post): postgresql-server-noarch >= %pgmajor Requires(postun): postgresql-server-noarch >= %pgmajor Requires: %pgname-devel = %version Requires: %pgname-server = %version-%release # Installation of postgresql??-devel is exclusive Provides: postgresql-server-devel-exclusive = %pgmajor Conflicts: postgresql-server-devel-exclusive < %pgmajor %if %{with llvm} Requires: clang-devel %endif Requires: libxslt-devel Requires: openssl-devel Requires: pam-devel Requires: readline-devel Requires: zlib-devel Requires: pkgconfig(krb5) %if %{with selinux} Requires: libselinux-devel %endif %description server-devel PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the header files and libraries needed to compile C extensions that link into the PostgreSQL server. For building client applications, see the postgresql%pgmajor-devel package. %if %{with llvm} %package llvmjit Summary: Just-in-time compilation support for PostgreSQL Group: Productivity/Databases/Servers Provides: postgresql-llvmjit-implementation = %version-%release Requires: %pgname-server = %version-%release Requires: postgresql-llvmjit-noarch >= %pgmajor %description llvmjit PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, sub-queries, triggers, and user-defined types and functions. This 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 %package test Summary: The test suite for PostgreSQL Group: Productivity/Databases/Servers Provides: postgresql-test-implementation = %version-%release Requires: %pgname-server = %version Requires: postgresql-test-noarch >= %pgmajor %description test This package contains the sources and pre-built binaries of various tests for the PostgreSQL database management system, including regression tests and benchmarks. %package docs Summary: HTML Documentation for PostgreSQL Group: Productivity/Databases/Tools Provides: postgresql-docs-implementation = %version-%release Requires: postgresql-docs-noarch >= %pgmajor %description docs PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the HTML documentation for PostgreSQL. The start page is: file:///usr/share/doc/packages/%pgname/html/index.html . Manual pages for the PostgreSQL SQL statements can be found in the postgresql package. %package contrib Summary: Contributed Extensions and Additions to PostgreSQL Group: Productivity/Databases/Tools Provides: postgresql-contrib-implementation = %version-%release Requires: postgresql-contrib-noarch >= %pgmajor Requires(post): %pgname >= %pgmajor Requires: %pgname >= %pgmajor PreReq: %pgname-server = %version-%release %description contrib PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. The postgresql-contrib package includes extensions and additions that are distributed along with the PostgreSQL sources, but are not (yet) officially part of the PostgreSQL core. Documentation for the modules contained in this package can be found in /usr/share/doc/packages/postgresql/contrib. %package plperl Summary: The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL Group: Productivity/Databases/Servers Provides: postgresql-plperl-implementation = %version-%release Requires: %pgname-server = %version-%release Requires: perl = %perl_version Requires: postgresql-plperl-noarch >= %pgmajor %description plperl This package contains the the PL/Tcl, PL/Perl, and PL/Python procedural languages for the back-end. With these modules one can use Perl, Python, and Tcl to write stored procedures, functions and triggers. PostgreSQL also offers the builtin procedural language PL/SQL. %package plpython Summary: The PL/Python Procedural Languages for PostgreSQL Group: Productivity/Databases/Servers Provides: postgresql-plpython-implementation = %version-%release Requires: %pgname-server = %version-%release Requires: postgresql-plpython-noarch >= %pgmajor Requires: python %description plpython PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the PL/Python procedural language for PostgreSQL. With this module one can use Python to write stored procedures, functions, and triggers. PostgreSQL also offers the built-in procedural language PL/SQL which is included in the postgresql-server package. %package pltcl Summary: PL/Tcl Procedural Language for PostgreSQL Group: Productivity/Databases/Tools Provides: postgresql-pltcl-implementation = %version-%release Requires: %pgname-server = %version Requires: postgresql-pltcl-noarch >= %pgmajor Requires: tcl %description pltcl PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the PL/Tcl procedural language for PostgreSQL. With thie module one can use Tcl to write stored procedures, functions, and triggers. PostgreSQL also offers the built-in procedural language PL/SQL which is included in the postgresql-server package. %endif %prep %setup -q -n postgresql-%pkg_version # Keep the timestamp of configure, because patching it would otherwise # confuse PostgreSQL's build system touch -r configure tmp %patch1 %patch2 %patch4 %patch6 -p1 %patch8 -p1 %patch9 touch -r tmp configure rm tmp find src/test/ -name '*.orig' -delete find -name .gitignore -delete %build %global _lto_cflags %{_lto_cflags} -ffat-lto-objects export PYTHON=python3 PACKAGE_TARNAME=%pgname %configure \ --bindir=%pgbindir \ --libdir=%pglibdir \ --includedir=%pgincludedir \ --datadir=%pgdatadir \ --docdir=%pgdocdir \ --mandir=%pgmandir \ --disable-rpath \ --enable-nls \ --enable-thread-safety \ --enable-integer-datetimes \ %if %buildmain --with-python \ --with-perl \ --with-tcl \ --with-tclconfig=%_libdir \ --with-pam \ --with-uuid=e2fs \ --with-libxml \ --with-libxslt \ %if %{with systemd_notify} --with-systemd \ %endif %if %{with selinux} --with-selinux \ %endif %if %{with icu} --with-icu \ %endif %if %{with llvm} --with-llvm \ %endif %else --without-readline \ %endif --with-openssl \ --with-ldap \ --with-gssapi \ --with-krb5 \ --with-system-tzdata=/usr/share/zoneinfo %if !%buildmain # Disabled smp_mflags as some dependencies are incorrect in the interfaces code are incorrect which leads to failed builds make -C src/interfaces # %{?_smp_mflags} %else make %{?_smp_mflags} PACKAGE_TARNAME=%pgname %if %{with check} %check # # Run the regression tests. # make check || { for f in src/test/regress/log/* {,src/test/regress/}regression.diffs; do if test -f $f; then cat $f fi done exit 1 } %endif %endif %install %if %buildmain make DESTDIR=%buildroot PACKAGE_TARNAME=%pgname install install-docs mv %buildroot%pgincludedir/{server,..} make DESTDIR=%buildroot PACKAGE_TARNAME=%pgname -C src/interfaces uninstall rm -rf %buildroot%pgincludedir/* mv %buildroot%pgincludedir{/../server,} # {{{ the test package mkdir -p %buildroot%pgtestdir/regress install -sm 0755 contrib/spi/{refint.so,autoinc.so} %buildroot%pgtestdir/regress install -sm 0755 src/test/regress/{pg_regress,regress.so} %buildroot%pgtestdir/regress for i in src/test/regress/{data,expected,input,output,sql}; do cp -r $i %buildroot%pgtestdir/regress/ done install -m 0644 src/test/regress/{serial,parallel}_schedule %buildroot%pgtestdir/regress # }}} %endif %if %builddevel || %buildlibs make DESTDIR=%buildroot PACKAGE_TARNAME=%pgname -C src/include install make DESTDIR=%buildroot PACKAGE_TARNAME=%pgname -C src/interfaces install rm -rf %buildroot%pgincludedir/server %endif # The client libraries go to libdir mkdir -p %buildroot/%_libdir ls %buildroot%pglibdir/lib* | grep -v walreceiver | xargs mv -t %buildroot/%_libdir mv %buildroot%pglibdir/pkgconfig %buildroot%_libdir find %buildroot%_libdir/pkgconfig -type f -exec sed -i 's, -L%pglibdir,,' '{}' + # Don't ship static libraries, # libpgport.a and libpgcommon.a are needed, though. rm -f $(ls %buildroot/%_libdir/*.a %buildroot%pglibdir/*.a | grep -F -v -e libpgport.a -e libpgcommon.a) %if %buildmain # # Install and collect the contrib stuff # touch flag; sleep 1 # otherwise we have installed files that are not newer than flag make DESTDIR=%buildroot -C contrib install find %buildroot -type f -cnewer flag -printf "/%%P\n" | grep -v -e %_docdir -e %pgbindir -e %pgincludedir -e %pglibdir/bitcode \ > contrib.files rm flag install -d -m 750 %buildroot/var/lib/pgsql install -d -m755 %buildroot%pgdocdir cp doc/KNOWN_BUGS doc/MISSING_FEATURES COPYRIGHT \ README HISTORY %buildroot%pgdocdir cp -a %SOURCE3 %buildroot%pgdocdir/README.SUSE # Use versioned names for the man pages: for f in %buildroot%pgmandir/man*/*; do mv $f ${f}pg%pgmajor done %endif mkdir -p %buildroot{%_bindir,%_mandir/man1} mkdir -p %buildroot/etc/alternatives genlists () { # usage: genlists packagename basenames PKG=$1 shift for f in $@ do BIN=%_bindir/$f ALTBIN=/etc/alternatives/$f PGBIN=%pgbindir/$f MAN=%pgmandir/man1/$f.1* touch %buildroot$ALTBIN ln -s $ALTBIN %buildroot$BIN echo "$PGBIN" >> $PKG.files echo "$BIN" >> $PKG.files echo "%ghost $ALTBIN" >> $PKG.files test -e %buildroot$MAN && echo "%doc $MAN" >> $PKG.files %find_lang $f-%pgmajor $PKG.files ||: done } %if %buildmain genlists main \ createdb clusterdb createuser dropdb \ dropuser pg_dump pg_dumpall pg_restore pg_rewind psql vacuumdb \ reindexdb pg_basebackup pg_receivewal pg_isready pg_recvlogical pg_checksums %find_lang plpgsql-%pgmajor main.files %find_lang pgscripts-%pgmajor main.files genlists server \ initdb pg_ctl pg_controldata pg_resetwal pg_waldump postgres postmaster genlists server-devel \ pg_config genlists contrib \ oid2name pg_archivecleanup pg_standby pg_test_fsync pg_upgrade \ pgbench vacuumlo pg_test_timing for pl in plperl plpython pltcl; do %find_lang $pl-%{pgmajor} $pl.lang done ln -s /etc/alternatives/postgresql %buildroot/usr/lib/postgresql touch %buildroot/etc/alternatives/postgresql # Remove mostly unneeded buildtime requirements for server extensions sed -i '/^LIBS = /s/= .*/=/' %buildroot/%pglibdir/pgxs/src/Makefile.global %endif %if %builddevel # Make sure we can also link agaist newer versions pushd %buildroot%_libdir for f in *.so; do ln -sf $f.? $f done popd mkdir -p %buildroot%pgmandir/man1 cp -a doc/src/sgml/man1/ecpg.1 %buildroot%pgmandir/man1/ecpg.1pg%pgmajor # No update-alternatives, devel-packages are exclusive ln -s %pgbindir/ecpg %buildroot%_bindir/ecpg %find_lang ecpg-%{pgmajor} devel.files # Build up the file lists for the libpq and libecpg packages cat > libpq.files < libecpg.files <