#
%define beta %{nil}
-%define pgsqlversion 12
-%define pgsqlpriority 120
+%define pgsqlversion 14
+%define pgsqlpriority 140
Summary: PostgreSQL Data Base Management System
Summary(de.UTF-8): PostgreSQL Datenbankverwaltungssystem
Summary(uk.UTF-8): PostgreSQL - система керування базами даних
Summary(zh_CN.UTF-8): PostgreSQL 客户端程序和库文件
Name: postgresql-%{pgsqlversion}
-Version: %{pgsqlversion}.0
-Release: 1
+Version: %{pgsqlversion}.2
+Release: 3
License: BSD
Group: Applications/Databases
Source0: http://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2
-# Source0-md5: 87545416ef021eee8621d31a93fcc899
+# Source0-md5: aae1ede6de233e2d44437d66bc1cd3b8
Source1: postgresql.init
Source2: pgsql-Database-HOWTO-html.tar.gz
# Source2-md5: 5b656ddf1db41965761f85204a14398e
Patch1: postgresql-absolute_dbpaths.patch
Patch2: postgresql-ecpg-includedir.patch
Patch3: per-version-dirs.patch
-Patch4: postgresql-disable_horology_test.patch
+Patch4: postgresql-tests.patch
Patch5: postgresql-heimdal.patch
Patch6: postgresql-link.patch
Patch7: socket-dir-fixes.patch
+Patch8: postgresql-autoconf.patch
URL: http://www.postgresql.org/
BuildRequires: autoconf >= 2.69
BuildRequires: automake
BuildRequires: pam-devel
%{?with_perl:BuildRequires: perl-devel}
%if %{with python}
-BuildRequires: python >= 1:2.3
-BuildRequires: python-devel >= 1:2.3
-BuildRequires: python-modules >= 1:2.3
+BuildRequires: python3
+BuildRequires: python3-devel
+BuildRequires: python3-modules
%endif
BuildRequires: readline-devel >= 4.2
BuildRequires: rpmbuild(macros) >= 1.671
Requires(post,preun): /sbin/chkconfig
Requires(pre): /bin/id
Requires(pre): /usr/bin/getgid
-Requires(triggerpostun): /bin/id
-Requires(triggerpostun): /usr/sbin/usermod
+Requires(post): /bin/id
+Requires(post): /usr/sbin/usermod
Requires: %{name}-clients = %{version}-%{release}
Requires: %{name}-dirs = %{version}-%{release}
Requires: postgresql-libs >= %{version}-%{release}
# omitted contribs:
# spi, test_decoding, worker_spi - examples/tests
# tsearch2 - old module for compatibility only
-%define contrib_modules adminpack auth_delay auto_explain bloom btree_gin btree_gist citext cube dblink dict_int dict_xsyn earthdistance file_fdw fuzzystrmatch hstore %{?with_perl:hstore_plperl} %{?with_python:hstore_plpython} intagg intarray isn lo ltree %{?with_python:ltree_plpython} oid2name pageinspect passwordcheck pg_buffercache pg_freespacemap pg_prewarm pg_standby pg_stat_statements pg_trgm pg_visibility pgcrypto pgrowlocks pgstattuple postgres_fdw seg %{?with_selinux:sepgsql} sslinfo tablefunc tcn tsm_system_rows tsm_system_time unaccent uuid-ossp vacuumlo xml2
+%define contrib_modules adminpack amcheck auth_delay auto_explain bloom %{?with_perl:bool_plperl} btree_gin btree_gist citext cube dblink dict_int dict_xsyn earthdistance file_fdw fuzzystrmatch hstore %{?with_perl:hstore_plperl} %{?with_python:hstore_plpython} intagg intarray isn %{?with_perl:jsonb_plperl} %{?with_python:jsonb_plpython} lo ltree %{?with_python:ltree_plpython} oid2name old_snapshot pageinspect passwordcheck pg_buffercache pg_freespacemap pg_prewarm pg_stat_statements pg_surgery pg_trgm pg_visibility pgcrypto pgrowlocks pgstattuple postgres_fdw seg %{?with_selinux:sepgsql} spi sslinfo tablefunc tcn tsm_system_rows tsm_system_time unaccent uuid-ossp vacuumlo xml2
%description
PostgreSQL Data Base Management System (formerly known as Postgres,
Summary(pl.UTF-8): PL/Python - język proceduralny bazy danych PostgreSQL
Group: Applications/Databases
Requires: %{name} = %{version}-%{release}
-%pyrequires_eq python
+%pyrequires_eq python3
Obsoletes: postgresql-module-plpython
%description module-plpython
%patch5 -p1
%patch6 -p1
%patch7 -p1
+%patch8 -p1
# force rebuild of bison/flex files
find src -name \*.l -o -name \*.y | xargs touch
tar zxf %{SOURCE2} -C howto
%if %{with python}
-%py_comp $RPM_BUILD_ROOT%{py_libdir}
-%py_ocomp $RPM_BUILD_ROOT%{py_libdir}
+%py3_comp $RPM_BUILD_ROOT%{py3_libdir}
+%py3_ocomp $RPM_BUILD_ROOT%{py3_libdir}
%endif
# find locales
for f in libpq5 pgscripts postgres psql initdb ecpg ecpglib6 \
plpgsql %{?with_perl:plperl} %{?with_python:plpython} \
- pg_archivecleanup pg_basebackup pg_checksums pg_config pg_controldata pg_ctl pg_dump pg_resetwal pg_rewind pg_test_fsync pg_test_timing pg_upgrade pg_waldump; do
+ pg_amcheck pg_archivecleanup pg_basebackup pg_checksums pg_config pg_controldata pg_ctl pg_dump pg_resetwal pg_rewind pg_test_fsync pg_test_timing pg_upgrade pg_verifybackup pg_waldump; do
%find_lang $f-%{pgsqlversion}
done
# merge locales
cat $(for f in $@; do echo ${f}-%{pgsqlversion}.lang ; done)
}
merge_lang pgscripts postgres plpgsql \
- pg_basebackup pg_checksums pg_controldata pg_resetwal pg_rewind pg_upgrade pg_test_fsync pg_test_timing pg_waldump > main.lang
+ pg_amcheck pg_basebackup pg_checksums pg_config pg_controldata pg_resetwal pg_rewind pg_test_fsync pg_test_timing pg_upgrade pg_verifybackup pg_waldump > main.lang
merge_lang psql initdb \
pg_archivecleanup pg_ctl pg_dump > clients.lang
# package it...? nah, why bother.
%{__rm} -r $RPM_BUILD_ROOT%{pgsqldatadir}/doc/html
+%{__rm} -r $RPM_BUILD_ROOT%{pgsqldatadir}/doc/extension/*.example
%clean
rm -rf $RPM_BUILD_ROOT
%attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) /etc/sysconfig/postgresql-%{pgsqlversion}
%attr(755,root,root) %{pgsqllibdir}/bin/initdb
+%attr(755,root,root) %{pgsqllibdir}/bin/pg_amcheck
%attr(755,root,root) %{pgsqllibdir}/bin/pg_basebackup
%attr(755,root,root) %{pgsqllibdir}/bin/pg_checksums
%attr(755,root,root) %{pgsqllibdir}/bin/pg_controldata
%attr(755,root,root) %{pgsqllibdir}/bin/pg_test_fsync
%attr(755,root,root) %{pgsqllibdir}/bin/pg_test_timing
%attr(755,root,root) %{pgsqllibdir}/bin/pg_upgrade
+%attr(755,root,root) %{pgsqllibdir}/bin/pg_verifybackup
%attr(755,root,root) %{pgsqllibdir}/bin/pg_waldump
%attr(755,root,root) %{pgsqllibdir}/bin/pgbench
%attr(755,root,root) %{pgsqllibdir}/bin/postgres
%attr(755,root,root) %{pgsqllibdir}/bin/postmaster
-%attr(755,root,root) %{moduledir}/ascii_and_mic.so
%attr(755,root,root) %{moduledir}/cyrillic_and_mic.so
%attr(755,root,root) %{moduledir}/dict_int.so
%attr(755,root,root) %{moduledir}/dict_snowball.so
%{pgsqldatadir}/*.bki
%{pgsqldatadir}/*.sample
-%{pgsqldatadir}/*.description
-%{pgsqldatadir}/*.shdescription
%{pgsqldatadir}/*.sql
%{pgsqldatadir}/*.txt
%{pgsqldatadir}/timezonesets
%dir %{pgsqldatadir}/contrib
%{pgsqldatadir}/man/man1/initdb.1*
+%{pgsqldatadir}/man/man1/pg_amcheck.1*
%{pgsqldatadir}/man/man1/pg_basebackup.1*
%{pgsqldatadir}/man/man1/pg_checksums.1*
%{pgsqldatadir}/man/man1/pg_controldata.1*
%{pgsqldatadir}/man/man1/pg_receivewal.1*
%{pgsqldatadir}/man/man1/pg_recvlogical.1*
%{pgsqldatadir}/man/man1/pg_rewind.1*
+%{pgsqldatadir}/man/man1/pg_verifybackup.1*
%{pgsqldatadir}/man/man1/pg_waldump.1*
%{pgsqldatadir}/man/man1/pg_test_fsync.1*
%{pgsqldatadir}/man/man1/pg_test_timing.1*
%if %{with python}
%files module-plpython -f plpython-%{pgsqlversion}.lang
%defattr(644,root,root,755)
-%attr(755,root,root) %{moduledir}/plpython2.so
+%attr(755,root,root) %{moduledir}/plpython3.so
%{extensiondir}/plpython*--*.sql
%{extensiondir}/plpython*.control
%endif
%files contrib
%defattr(644,root,root,755)
-%doc contrib/README
+%doc contrib/README contrib/spi/*.example
%attr(755,root,root) %{pgsqllibdir}/bin/oid2name
-%attr(755,root,root) %{pgsqllibdir}/bin/pg_standby
%attr(755,root,root) %{pgsqllibdir}/bin/vacuumlo
%attr(755,root,root) %{moduledir}/_int.so
%attr(755,root,root) %{moduledir}/adminpack.so
+%attr(755,root,root) %{moduledir}/amcheck.so
%attr(755,root,root) %{moduledir}/auth_delay.so
%attr(755,root,root) %{moduledir}/auto_explain.so
+%attr(755,root,root) %{moduledir}/autoinc.so
%attr(755,root,root) %{moduledir}/bloom.so
%attr(755,root,root) %{moduledir}/btree_gin.so
%attr(755,root,root) %{moduledir}/btree_gist.so
%attr(755,root,root) %{moduledir}/file_fdw.so
%attr(755,root,root) %{moduledir}/fuzzystrmatch.so
%attr(755,root,root) %{moduledir}/hstore.so
+%attr(755,root,root) %{moduledir}/insert_username.so
%attr(755,root,root) %{moduledir}/isn.so
%attr(755,root,root) %{moduledir}/ltree.so
+%attr(755,root,root) %{moduledir}/moddatetime.so
+%attr(755,root,root) %{moduledir}/old_snapshot.so
%attr(755,root,root) %{moduledir}/pageinspect.so
%attr(755,root,root) %{moduledir}/passwordcheck.so
%attr(755,root,root) %{moduledir}/pg_buffercache.so
%attr(755,root,root) %{moduledir}/pg_freespacemap.so
%attr(755,root,root) %{moduledir}/pg_prewarm.so
%attr(755,root,root) %{moduledir}/pg_stat_statements.so
+%attr(755,root,root) %{moduledir}/pg_surgery.so
%attr(755,root,root) %{moduledir}/pg_visibility.so
%attr(755,root,root) %{moduledir}/pgrowlocks.so
%attr(755,root,root) %{moduledir}/pgstattuple.so
%attr(755,root,root) %{moduledir}/postgres_fdw.so
+%attr(755,root,root) %{moduledir}/refint.so
%attr(755,root,root) %{moduledir}/seg.so
%attr(755,root,root) %{moduledir}/sslinfo.so
%attr(755,root,root) %{moduledir}/tcn.so
%attr(755,root,root) %{moduledir}/uuid-ossp.so
%{extensiondir}/adminpack--*.sql
%{extensiondir}/adminpack.control
+%{extensiondir}/amcheck--*.sql
+%{extensiondir}/amcheck.control
+%{extensiondir}/autoinc--*.sql
+%{extensiondir}/autoinc.control
%{extensiondir}/bloom--*.sql
%{extensiondir}/bloom.control
%{extensiondir}/btree_gin--*.sql
%{extensiondir}/fuzzystrmatch.control
%{extensiondir}/hstore--*.sql
%{extensiondir}/hstore.control
+%{extensiondir}/insert_username--*.sql
+%{extensiondir}/insert_username.control
%{extensiondir}/intarray--*.sql
%{extensiondir}/intarray.control
%{extensiondir}/intagg--*.sql
%{extensiondir}/isn.control
%{extensiondir}/ltree--*.sql
%{extensiondir}/ltree.control
+%{extensiondir}/moddatetime--*.sql
+%{extensiondir}/moddatetime.control
+%{extensiondir}/old_snapshot--*.sql
+%{extensiondir}/old_snapshot.control
%{extensiondir}/pageinspect--*.sql
%{extensiondir}/pageinspect.control
%{extensiondir}/pg_buffercache--*.sql
%{extensiondir}/pg_prewarm.control
%{extensiondir}/pg_stat_statements--*.sql
%{extensiondir}/pg_stat_statements.control
+%{extensiondir}/pg_surgery--*.sql
+%{extensiondir}/pg_surgery.control
%{extensiondir}/pg_visibility--*.sql
%{extensiondir}/pg_visibility.control
%{extensiondir}/pgrowlocks--*.sql
%{extensiondir}/pgstattuple.control
%{extensiondir}/postgres_fdw--*.sql
%{extensiondir}/postgres_fdw.control
+%{extensiondir}/refint--*.sql
+%{extensiondir}/refint.control
%{extensiondir}/seg--*.sql
%{extensiondir}/seg.control
%{extensiondir}/sslinfo--*.sql
%{extensiondir}/uuid-ossp--*.sql
%{extensiondir}/uuid-ossp.control
%if %{with perl}
+%attr(755,root,root) %{moduledir}/bool_plperl.so
%attr(755,root,root) %{moduledir}/hstore_plperl.so
+%attr(755,root,root) %{moduledir}/jsonb_plperl.so
+%{extensiondir}/bool_plperl--*.sql
+%{extensiondir}/bool_plperl.control
+%{extensiondir}/bool_plperlu--*.sql
+%{extensiondir}/bool_plperlu.control
%{extensiondir}/hstore_plperl--*.sql
%{extensiondir}/hstore_plperl.control
%{extensiondir}/hstore_plperlu--*.sql
%{extensiondir}/hstore_plperlu.control
+%{extensiondir}/jsonb_plperl--*.sql
+%{extensiondir}/jsonb_plperl.control
+%{extensiondir}/jsonb_plperlu--*.sql
+%{extensiondir}/jsonb_plperlu.control
%endif
%if %{with python}
-%attr(755,root,root) %{moduledir}/hstore_plpython2.so
-%attr(755,root,root) %{moduledir}/ltree_plpython2.so
+%attr(755,root,root) %{moduledir}/hstore_plpython3.so
+%attr(755,root,root) %{moduledir}/jsonb_plpython3.so
+%attr(755,root,root) %{moduledir}/ltree_plpython3.so
%{extensiondir}/hstore_plpythonu--*.sql
%{extensiondir}/hstore_plpythonu.control
%{extensiondir}/hstore_plpython2u--*.sql
%{extensiondir}/hstore_plpython2u.control
%{extensiondir}/hstore_plpython3u--*.sql
%{extensiondir}/hstore_plpython3u.control
+%{extensiondir}/jsonb_plpythonu--*.sql
+%{extensiondir}/jsonb_plpythonu.control
+%{extensiondir}/jsonb_plpython2u--*.sql
+%{extensiondir}/jsonb_plpython2u.control
+%{extensiondir}/jsonb_plpython3u--*.sql
+%{extensiondir}/jsonb_plpython3u.control
%{extensiondir}/ltree_plpythonu--*.sql
%{extensiondir}/ltree_plpythonu.control
%{extensiondir}/ltree_plpython2u--*.sql
%{extensiondir}/ltree_plpython3u.control
%endif
%{pgsqldatadir}/man/man1/oid2name.1*
-%{pgsqldatadir}/man/man1/pg_standby.1*
%{pgsqldatadir}/man/man1/vacuumlo.1*