#
%define beta %{nil}
-%define pgver 10
-%define pgminver 5
+%define pgsqlversion 14
+%define pgsqlpriority 140
Summary: PostgreSQL Data Base Management System
Summary(de.UTF-8): PostgreSQL Datenbankverwaltungssystem
Summary(tr.UTF-8): Veri Tabanı Yönetim Sistemi
Summary(uk.UTF-8): PostgreSQL - система керування базами даних
Summary(zh_CN.UTF-8): PostgreSQL 客户端程序和库文件
-Name: postgresql%{pgver}
-Version: %{pgver}.%{pgminver}
-Release: 1.1
+Name: postgresql-%{pgsqlversion}
+Version: %{pgsqlversion}.3
+Release: 1
License: BSD
Group: Applications/Databases
Source0: http://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2
-# Source0-md5: a5fe5fdff2d6c28f65601398be0950df
+# Source0-md5: c83c28c774dd55b078f7dae0e30163be
Source1: postgresql.init
Source2: pgsql-Database-HOWTO-html.tar.gz
# Source2-md5: 5b656ddf1db41965761f85204a14398e
Source3: postgresql.sysconfig
+Source4: postgresql.logrotate
Patch0: postgresql-conf.patch
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: libpgport-pkglibdir.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(pre): /usr/sbin/groupadd
-Requires(pre): /usr/sbin/useradd
-Requires(triggerpostun): /bin/id
-Requires(triggerpostun): /usr/sbin/usermod
-Requires: %{name}-clients >= %{version}-%{release}
-Requires: postgresql-libs = %{version}-%{release}
+Requires(post): /bin/id
+Requires(post): /usr/sbin/usermod
+Requires: %{name}-clients = %{version}-%{release}
+Requires: %{name}-dirs = %{version}-%{release}
+Requires: postgresql-libs >= %{version}-%{release}
Requires: rc-scripts >= 0.4.3.0
Requires: tzdata
+Obsoletes: postgresql
Obsoletes: postgresql-module-plpgsql
Obsoletes: postgresql-module-tsearch2
Obsoletes: postgresql-server
Obsoletes: postgresql-test
BuildRoot: %{tmpdir}/%{name}-%{version}-root-%(id -u -n)
-%define pgsqldatadir %{_datadir}/postgresql/%{pgver}
-%define pgsqllibdir %{_libdir}/postgresql/%{pgver}
+%define pgsqldatadir %{_datadir}/postgresql/%{pgsqlversion}
+%define pgsqllibdir %{_libdir}/postgresql/%{pgsqlversion}
%define moduledir %{pgsqllibdir}/lib
%define extensiondir %{pgsqldatadir}/extension
# 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 chkpass 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,
PostgreSQL może być uruchomiony pod następującymi systemami: Solaris,
SunOS, HPUX, AIX, Linux, Irix, FreeBSD i innymi systemami uniksowymi.
+%package -n postgresql-common
+Summary: Common PostgreSQL files and directories
+Summary(pl.UTF-8): PostgreSQL - wspólne pliki i katalogi
+Group: Applicataion/Databases
+Requires(pre): /usr/sbin/groupadd
+Requires(pre): /usr/sbin/useradd
+
+%description -n postgresql-common
+Common PostgreSQL files and directories.
+
+%description -n postgresql-common -l pl.UTF-8
+PostgreSQL - wspólne pliki i katalogi.
+
+%package dirs
+Summary: Common directories for PostgresSQL %{pgsqlversion}
+Summary(pl.UTF-8): Wspólne pliki i katalogi dla PostgreSQL %{pgsqlversion}
+Group: Applicataion/Databases
+Requires: postgresql-common >= %{version}-%{release}
+
+%description dirs
+Common directories for PostgresSQL %{pgsqlversion}
+
+%description dirs -l pl.UTF-8
+Wspólne pliki i katalogi dla PostgreSQL %{pgsqlversion}
+
%package -n postgresql-devel
Summary: PostgreSQL development header files and libraries
Summary(de.UTF-8): PostgreSQL-Entwicklungs-Header-Dateien und Libraries
Summary(tr.UTF-8): PostgreSQL başlık dosyaları ve kitaplıklar
Summary(uk.UTF-8): PostgreSQL - хедери та бібліотеки програміста
Group: Development/Libraries
-Requires: postgresql-libs = %{version}-%{release}
+Requires: alternatives
+Requires: postgresql-libs >= %{version}-%{release}
%description -n postgresql-devel
This package contains header files and libraries required to compile
Summary: PostgreSQL backend development header files
Summary(pl.UTF-8): PostgreSQL - pliki nagłówkowe dla backendu
Group: Development/Libraries
-Requires: postgresql-devel = %{version}-%{release}
-Requires: postgresql-libs = %{version}-%{release}
+Requires: postgresql-devel >= %{version}-%{release}
+Requires: postgresql-libs >= %{version}-%{release}
+Obsoletes: postgresql-backend-devel
%description backend-devel
This package contains header files required to compile functions that
Summary(uk.UTF-8): Клієнтські програми, необхідні для доступу до сервера PostgreSQL
Group: Applications/Databases
Requires: alternatives
-Requires: postgresql-libs = %{version}-%{release}
+Requires: %{name}-dirs = %{version}-%{release}
+Requires: postgresql-libs >= %{version}-%{release}
+Obsoletes: postgresql-clients
%description clients
This package includes only the clients needed to access an PostgreSQL
Summary: Documentation for PostgreSQL
Summary(pl.UTF-8): Dodatkowa dokumantacja dla PostgreSQL
Group: Applications/Databases
+Obsoletes: postgresql-doc
%description doc
This package includes documentation and HOWTO for programmer, admin
Summary(pt_BR.UTF-8): Biblioteca compartilhada do PostgreSQL
Summary(zh_CN.UTF-8): PostgreSQL 客户所需要的共享库
Group: Libraries
+Requires: postgresql-common >= %{version}-%{release}
%description -n postgresql-libs
PostgreSQL shared libraries.
Summary: Embedded SQL in C interface
Summary(pl.UTF-8): Interfejs wbudowanego SQL-a w język C
Group: Libraries
-Requires: postgresql-libs = %{version}-%{release}
-Requires: postgresql-ecpg-libs = %{version}-%{release}
+Requires: %{name}-dirs = %{version}-%{release}
+Requires: postgresql-libs >= %{version}-%{release}
+Requires: postgresql-ecpg-libs >= %{version}-%{release}
+Obsoletes: postgresql-ecpg
%description ecpg
Embedded SQL in C interface.
Summary: Embedded SQL in C interface files
Summary(pl.UTF-8): Pliki programistyczne interfejsu wbudowanego SQL-a w język C
Group: Development/Libraries
-Requires: postgresql-devel = %{version}-%{release}
-Requires: postgresql-ecpg-devel = %{version}-%{release}
+Requires: postgresql-devel >= %{version}-%{release}
+Requires: postgresql-ecpg-devel >= %{version}-%{release}
%description -n postgresql-ecpg-devel
Embedded SQL in C interface files.
Summary(ru.UTF-8): Статические библиотеки для программирования с PostgreSQL
Summary(uk.UTF-8): Статичні бібліотеки для програмування з PostgreSQL
Group: Development/Libraries
-Requires: postgresql-devel = %{version}-%{release}
+Requires: postgresql-devel >= %{version}-%{release}
%description -n postgresql-ecpg-static
PostgreSQL static libraries.
Summary(ru.UTF-8): Статические библиотеки для программирования с PostgreSQL
Summary(uk.UTF-8): Статичні бібліотеки для програмування з PostgreSQL
Group: Development/Libraries
-Requires: postgresql-devel = %{version}-%{release}
+Requires: postgresql-devel >= %{version}-%{release}
%description -n postgresql-static
PostgreSQL static libraries.
Summary(pl.UTF-8): PL/perl - język proceduralny bazy danych PostgreSQL
Group: Applications/Databases
Requires: %{name} = %{version}-%{release}
+Obsoletes: postgresql-module-plperl
%description module-plperl
From PostgreSQL documentation:
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
From PostgreSQL documentation:
Group: Applications/Databases
Requires: %{name} = %{version}-%{release}
Requires: tcl(Pgtcl)
+Obsoletes: postgresql-module-pltcl
%description module-pltcl
From PostgreSQL documentation:
Summary(pl.UTF-8): Moduł dblink dla PostgreSQL-a
Group: Applications/Databases
Requires: %{name} = %{version}-%{release}
+Obsoletes: postgresql-module-dblink
%description module-dblink
dblink module for PostgreSQL provides functions returning results from
Summary(pl.UTF-8): Moduł Large Objects dla PostgreSQL-a
Group: Applications/Databases
Requires: %{name} = %{version}-%{release}
+Obsoletes: postgresql-module-lo
%description module-lo
Large Objects module for PostgreSQL adds a new data type 'lo', some
Summary(pl.UTF-8): Dopasowanie trigramowe dla PostgreSQL-a
Group: Applications/Databases
Requires: %{name} = %{version}-%{release}
+Obsoletes: postgresql-module-pg_trgm
%description module-pg_trgm
This module provides functions and index classes for determining the
Summary(pl.UTF-8): Funkcje kryptograficzne dla PostgreSQL-a
Group: Applications/Databases
Requires: %{name} = %{version}-%{release}
+Obsoletes: postgresql-module-pgcrypto
%description module-pgcrypto
Cryptographic functions for PostgreSQL.
Group: Applications/Databases
Requires: %{name} = %{version}-%{release}
Requires: libselinux >= 2.1.10
+Obsoletes: postgresql-module-sepgsql
%description module-sepgsql
PostgreSQL external security provider using SELinux.
Summary(pl.UTF-8): Funkcje crosstab dla PostgreSQL-a
Group: Applications/Databases
Requires: %{name} = %{version}-%{release}
+Obsoletes: postgresql-module-tablefunc
%description module-tablefunc
crosstab functions for PostgreSQL.
Group: Applications/Databases
Requires: %{name} = %{version}-%{release}
Requires: libxml2 >= 1:2.6.23
+Obsoletes: postgresql-module-xml2
%description module-xml2
Module with XML functions provides both XPath querying and XSLT
Summary(pl.UTF-8): Różne moduły dołączone do PostgreSQL-a
Group: Applications/Databases
Requires: %{name} = %{version}-%{release}
+Obsoletes: postgresql-contrib
%description contrib
Miscellaneous PostgreSQL contrib modules.
%patch5 -p1
%patch6 -p1
%patch7 -p1
+%patch8 -p1
# force rebuild of bison/flex files
find src -name \*.l -o -name \*.y | xargs touch
--datadir=%{pgsqldatadir} \
--libdir=%{_libdir} \
--docdir=%{pgsqldatadir}/doc \
+ --localedir=%{_datadir}/locale \
--disable-rpath \
--enable-depend \
%{?with_systemtap:--enable-dtrace} \
%install
rm -rf $RPM_BUILD_ROOT
-install -d $RPM_BUILD_ROOT{%{_sysconfdir},/etc/{rc.d/init.d,sysconfig}} \
- $RPM_BUILD_ROOT/var/{lib/pgsql,log} \
+install -d $RPM_BUILD_ROOT{%{_sysconfdir},/etc/{logrotate.d,rc.d/init.d,sysconfig}} \
+ $RPM_BUILD_ROOT/var/{lib/postgresql/%{pgsqlversion},log/{archive,}/postgresql,run/postgresql} \
$RPM_BUILD_ROOT%{_examplesdir}/%{name}-%{version} \
- $RPM_BUILD_ROOT%{_mandir} \
- $RPM_BUILD_ROOT/home/services/postgres
+ $RPM_BUILD_ROOT{%{_bindir},%{_mandir}/man1}
install src/tutorial/*.sql $RPM_BUILD_ROOT%{_examplesdir}/%{name}-%{version}
DESTDIR=$RPM_BUILD_ROOT
done
-touch $RPM_BUILD_ROOT/var/log/pgsql
-
-sed -e 's,@pgsqlbindir@,%{pgsqllibdir}/bin,g' %{SOURCE1} >$RPM_BUILD_ROOT/etc/rc.d/init.d/postgresql10
-install %{SOURCE3} $RPM_BUILD_ROOT/etc/sysconfig/postgresql10
+sed -e 's,@pgsqlbindir@,%{pgsqllibdir}/bin,g; s,@pgsqlversion@,%{pgsqlversion},g;' %{SOURCE1} >$RPM_BUILD_ROOT/etc/rc.d/init.d/postgresql-%{pgsqlversion}
+sed -e 's,@pgsqlversion@,%{pgsqlversion},g;' %{SOURCE3} >$RPM_BUILD_ROOT/etc/sysconfig/postgresql-%{pgsqlversion}
+cp -a %{SOURCE4} $RPM_BUILD_ROOT/etc/logrotate.d/postgresql
install -d howto
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_config pg_controldata pg_ctl pg_dump pg_resetwal pg_rewind pg_test_fsync pg_test_timing pg_upgrade pg_waldump; do
- %find_lang $f-%{pgver}
+ 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
merge_lang() {
- cat $(for f in $@; do echo ${f}-%{pgver}.lang ; done)
+ cat $(for f in $@; do echo ${f}-%{pgsqlversion}.lang ; done)
}
merge_lang pgscripts postgres plpgsql \
- pg_basebackup 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
%if %{with tcl}
-%find_lang pltcl-%{pgver}
+%find_lang pltcl-%{pgsqlversion}
%endif
%if %{with selinux}
%{__mv} $RPM_BUILD_ROOT{%{pgsqldatadir}/contrib,%{extensiondir}}/sepgsql.sql
%endif
-cp -p src/pl/plperl/ppport.h $RPM_BUILD_ROOT%{_includedir}/postgresql/%{pgver}/server/
+cp -p src/pl/plperl/ppport.h $RPM_BUILD_ROOT%{_includedir}/postgresql/%{pgsqlversion}/server/
+
+%{__mv} $RPM_BUILD_ROOT{%{pgsqllibdir}/bin,%{_bindir}}/pg_config
+%{__mv} $RPM_BUILD_ROOT{%{pgsqldatadir}/man,%{_mandir}}/man1/pg_config.1
# 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
%pre
PG_DB_CLUSTERS=""
-if [ -f /etc/sysconfig/postgresql10 ]; then
- . /etc/sysconfig/postgresql10
+if [ -f /etc/sysconfig/postgresql-%{pgsqlversion} ]; then
+ . /etc/sysconfig/postgresql-%{pgsqlversion}
if [ -z "$PG_DB_CLUSTERS" -a -n "$POSTGRES_DATA_DIR" ]; then
PG_DB_CLUSTERS="$POSTGRES_DATA_DIR"
fi
foundold=0
for pgdir in $PG_DB_CLUSTERS; do
if [ -f $pgdir/PG_VERSION ]; then
- if [ $(cat $pgdir/PG_VERSION) != '%{pgver}' ]; then
+ if [ $(cat $pgdir/PG_VERSION) != '%{pgsqlversion}' ]; then
echo "Found database(s) in older, incompatible format in cluster $pgdir."
foundold=1
fi
echo
exit 1
fi
-%groupadd -g 88 -r postgres
-%useradd -M -o -r -u 88 -d /home/services/postgres -s /bin/sh -g postgres -c "PostgreSQL Server" postgres
-%triggerpostun -- %{name} < 7.2-2
+%triggerpostun -- postgresql < 10.5-2
if [ -n "`/bin/id -u postgres 2>/dev/null`" ]; then
- /usr/sbin/usermod -d /home/services/postgres postgres
+ /usr/sbin/usermod -d /var/lib/postgresql postgres
fi
+echo
+echo "This version of PostgreSQL uses new default location for database clusters."
+echo "Please move your existing clusters before starting PostgreSQL so they follow"
+echo "below scheme:"
+echo
+echo "/var/lib/postgresql/<version>/<name>"
+echo
+echo "where <version> means PostgreSQL version like 9.6 or 10 and name is cluster"
+echo "name of your choice. When done, be sure to update /etc/sysconfig/postgresql*"
+echo "files so they reflect your changes."
+echo
%post
-/sbin/chkconfig --add postgresql10
-%service postgresql10 restart "postgresql10 server"
+/sbin/chkconfig --add postgresql-%{pgsqlversion}
+%service postgresql-%{pgsqlversion} restart "postgresql-%{pgsqlversion} server"
%preun
if [ "$1" = "0" ]; then
- %service postgresql10 stop
- /sbin/chkconfig --del postgresql10
+ %service postgresql-%{pgsqlversion} stop
+ /sbin/chkconfig --del postgresql-%{pgsqlversion}
fi
-%post clients
+%pre -n postgresql-common
+%groupadd -g 88 -r postgres
+%useradd -M -o -r -u 88 -d /var/lib/postgresql -s /bin/sh -g postgres -c "PostgreSQL Server" postgres
+
+%posttrans clients
update-alternatives \
- --install %{_bindir}/clusterdb clusterdb %{pgsqllibdir}/bin/clusterdb %{pgver}%{pgminver} \
+ --install %{_bindir}/clusterdb clusterdb %{pgsqllibdir}/bin/clusterdb %{pgsqlpriority} \
--slave %{_mandir}/man1/clusterdb.1 clusterdb.1 %{pgsqldatadir}/man/man1/clusterdb.1* || :
update-alternatives \
- --install %{_bindir}/createdb createdb %{pgsqllibdir}/bin/createdb %{pgver}%{pgminver} \
+ --install %{_bindir}/createdb createdb %{pgsqllibdir}/bin/createdb %{pgsqlpriority} \
--slave %{_mandir}/man1/createdb.1 createdb.1 %{pgsqldatadir}/man/man1/createdb.1* || :
update-alternatives \
- --install %{_bindir}/createuser createuser %{pgsqllibdir}/bin/createuser %{pgver}%{pgminver} \
+ --install %{_bindir}/createuser createuser %{pgsqllibdir}/bin/createuser %{pgsqlpriority} \
--slave %{_mandir}/man1/createuser.1 createuser.1 %{pgsqldatadir}/man/man1/createuser.1* || :
update-alternatives \
- --install %{_bindir}/dropdb dropdb %{pgsqllibdir}/bin/dropdb %{pgver}%{pgminver} \
+ --install %{_bindir}/dropdb dropdb %{pgsqllibdir}/bin/dropdb %{pgsqlpriority} \
--slave %{_mandir}/man1/dropdb.1 dropdb.1 %{pgsqldatadir}/man/man1/dropdb.1* || :
update-alternatives \
- --install %{_bindir}/dropuser dropuser %{pgsqllibdir}/bin/dropuser %{pgver}%{pgminver} \
+ --install %{_bindir}/dropuser dropuser %{pgsqllibdir}/bin/dropuser %{pgsqlpriority} \
--slave %{_mandir}/man1/dropuser.1 dropuser.1 %{pgsqldatadir}/man/man1/dropuser.1* || :
update-alternatives \
- --install %{_bindir}/pg_archivecleanup pg_archivecleanup %{pgsqllibdir}/bin/pg_archivecleanup %{pgver}%{pgminver} \
+ --install %{_bindir}/pg_archivecleanup pg_archivecleanup %{pgsqllibdir}/bin/pg_archivecleanup %{pgsqlpriority} \
--slave %{_mandir}/man1/pg_archivecleanup.1 pg_archivecleanup.1 %{pgsqldatadir}/man/man1/pg_archivecleanup.1* || :
update-alternatives \
- --install %{_bindir}/pg_dump pg_dump %{pgsqllibdir}/bin/pg_dump %{pgver}%{pgminver} \
+ --install %{_bindir}/pg_dump pg_dump %{pgsqllibdir}/bin/pg_dump %{pgsqlpriority} \
--slave %{_mandir}/man1/pg_dump.1 pg_dump.1 %{pgsqldatadir}/man/man1/pg_dump.1* || :
update-alternatives \
- --install %{_bindir}/pg_dumpall pg_dumpall %{pgsqllibdir}/bin/pg_dumpall %{pgver}%{pgminver} \
+ --install %{_bindir}/pg_dumpall pg_dumpall %{pgsqllibdir}/bin/pg_dumpall %{pgsqlpriority} \
--slave %{_mandir}/man1/pg_dumpall.1 pg_dumpall.1 %{pgsqldatadir}/man/man1/pg_dumpall.1* || :
update-alternatives \
- --install %{_bindir}/pg_isready pg_isready %{pgsqllibdir}/bin/pg_isready %{pgver}%{pgminver} \
+ --install %{_bindir}/pg_isready pg_isready %{pgsqllibdir}/bin/pg_isready %{pgsqlpriority} \
--slave %{_mandir}/man1/pg_isready.1 pg_isready.1 %{pgsqldatadir}/man/man1/pg_isready.1* || :
update-alternatives \
- --install %{_bindir}/pg_restore pg_restore %{pgsqllibdir}/bin/pg_restore %{pgver}%{pgminver} \
+ --install %{_bindir}/pg_restore pg_restore %{pgsqllibdir}/bin/pg_restore %{pgsqlpriority} \
--slave %{_mandir}/man1/pg_restore.1 pg_restore.1 %{pgsqldatadir}/man/man1/pg_restore.1* || :
update-alternatives \
- --install %{_bindir}/psql psql %{pgsqllibdir}/bin/psql %{pgver}%{pgminver} \
+ --install %{_bindir}/psql psql %{pgsqllibdir}/bin/psql %{pgsqlpriority} \
--slave %{_mandir}/man1/psql.1 pgsql.1 %{pgsqldatadir}/man/man1/psql.1* || :
update-alternatives \
- --install %{_bindir}/reindexdb reindexdb %{pgsqllibdir}/bin/reindexdb %{pgver}%{pgminver} \
+ --install %{_bindir}/reindexdb reindexdb %{pgsqllibdir}/bin/reindexdb %{pgsqlpriority} \
--slave %{_mandir}/man1/reindexdb.1 reindexdb.1 %{pgsqldatadir}/man/man1/reindexdb.1* || :
update-alternatives \
- --install %{_bindir}/vacuumdb vacuumdb %{pgsqllibdir}/bin/vacuumdb %{pgver}%{pgminver} \
+ --install %{_bindir}/vacuumdb vacuumdb %{pgsqllibdir}/bin/vacuumdb %{pgsqlpriority} \
--slave %{_mandir}/man1/vacuumdb.1 vacuumdb.1 %{pgsqldatadir}/man/man1/vacuumdb.1* || :
-%postun clients
+%postun clients
if [ $1 -eq 0 ]; then
update-alternatives --remove clusterdb %{pgsqllibdir}/bin/clusterdb || :
update-alternatives --remove createdb %{pgsqllibdir}/bin/createdb || :
update-alternatives --remove vacuumdb %{pgsqllibdir}/bin/vacuumdb || :
fi
-%post -n postgresql-devel
-update-alternatives \
- --install %{_bindir}/pg_config pg_config %{pgsqllibdir}/bin/pg_config %{pgver}%{pgminver} \
- --slave %{_mandir}/man1/pg_config.1 pg_config.1 %{pgsqldatadir}/man/man1/pg_config.1* || :
-
%postun -n postgresql-devel
update-alternatives --remove pg_config %{pgsqllibdir}/bin/pg_config || :
-
%post -n postgresql-libs -p /sbin/ldconfig
%postun -n postgresql-libs -p /sbin/ldconfig
%files -f main.lang
%defattr(644,root,root,755)
-%doc COPYRIGHT README HISTORY doc/{bug.template,KNOWN_BUGS,MISSING_FEATURES,TODO}
-%attr(754,root,root) /etc/rc.d/init.d/postgresql10
-%attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) /etc/sysconfig/postgresql10
+%doc COPYRIGHT README HISTORY doc/{KNOWN_BUGS,MISSING_FEATURES,TODO}
+%attr(754,root,root) /etc/rc.d/init.d/postgresql-%{pgsqlversion}
+%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_ctl
%attr(755,root,root) %{pgsqllibdir}/bin/pg_resetwal
%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
%{extensiondir}/plpgsql--*.sql
%{extensiondir}/plpgsql.control
-%dir %{pgsqldatadir}
%{pgsqldatadir}/*.bki
%{pgsqldatadir}/*.sample
-%{pgsqldatadir}/*.description
-%{pgsqldatadir}/*.shdescription
%{pgsqldatadir}/*.sql
%{pgsqldatadir}/*.txt
%{pgsqldatadir}/timezonesets
%dir %{pgsqldatadir}/contrib
-%attr(700,postgres,postgres) /home/services/postgres
-%attr(700,postgres,postgres) %dir /var/lib/pgsql
-%attr(640,postgres,postgres) %config(noreplace) %verify(not md5 mtime size) /var/log/pgsql
-
%{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_ctl.1*
%{pgsqldatadir}/man/man1/pg_resetwal.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*
%{pgsqldatadir}/man/man1/postgres.1*
%{pgsqldatadir}/man/man1/postmaster.1*
+%files -n postgresql-common
+%defattr(644,root,root,755)
+%dir %{_libdir}/postgresql
+%dir %{_datadir}/postgresql
+%attr(700,postgres,postgres) %dir /var/lib/postgresql
+%attr(750,postgres,postgres) %dir /var/log/postgresql
+%attr(750,postgres,postgres) %dir /var/log/archive/postgresql
+%attr(700,postgres,postgres) %dir /var/run/postgresql
+%attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) /etc/logrotate.d/postgresql
+
+%files dirs
+%defattr(644,root,root,755)
+%dir %{pgsqllibdir}
+%dir %{pgsqllibdir}/bin
+%dir %{pgsqllibdir}/lib
+%dir %{pgsqldatadir}
+%dir %{pgsqldatadir}/man
+%dir %{pgsqldatadir}/man/man1
+%dir %{pgsqldatadir}/man/man3
+%dir %{pgsqldatadir}/man/man7
+%attr(700,postgres,postgres) %dir /var/lib/postgresql/%{pgsqlversion}
+
%files doc
%defattr(644,root,root,755)
%doc doc/src/sgml/html howto
%{_examplesdir}/%{name}-%{version}
-%files -n postgresql-libs -f libpq5-%{pgver}.lang
+%files -n postgresql-libs -f libpq5-%{pgsqlversion}.lang
%defattr(644,root,root,755)
%attr(755,root,root) %{_libdir}/libpq.so.*.*
%attr(755,root,root) %ghost %{_libdir}/libpq.so.5
-%files ecpg -f ecpg-%{pgver}.lang
+%files ecpg -f ecpg-%{pgsqlversion}.lang
%defattr(644,root,root,755)
%attr(755,root,root) %{pgsqllibdir}/bin/ecpg
%{pgsqldatadir}/man/man1/ecpg.1*
-%files -n postgresql-ecpg-libs -f ecpglib6-%{pgver}.lang
+%files -n postgresql-ecpg-libs -f ecpglib6-%{pgsqlversion}.lang
%attr(755,root,root) %{_libdir}/libecpg.so.*.*
%attr(755,root,root) %ghost %{_libdir}/libecpg.so.6
%attr(755,root,root) %{_libdir}/libecpg_compat.so.*.*
%{_libdir}/libecpg_compat.a
%{_libdir}/libpgtypes.a
-%files -n postgresql-devel -f pg_config-%{pgver}.lang
+%files -n postgresql-devel -f pg_config-%{pgsqlversion}.lang
%defattr(644,root,root,755)
-%attr(755,root,root) %{pgsqllibdir}/bin/pg_config
+%attr(755,root,root) %{_bindir}/pg_config
%attr(755,root,root) %{_libdir}/libpq.so
%dir %{_includedir}/postgresql
%{_includedir}/libpq-events.h
%{_includedir}/postgresql/internal/libpq
%{_includedir}/libpq
%{_libdir}/pkgconfig/libpq.pc
-%{pgsqldatadir}/man/man1/pg_config.1*
+%{_mandir}/man1/pg_config.1*
%files backend-devel
%defattr(644,root,root,755)
-%dir %{_includedir}/postgresql/%{pgver}
-%{_includedir}/postgresql/%{pgver}/server
+%dir %{_includedir}/postgresql/%{pgsqlversion}
+%{_includedir}/postgresql/%{pgsqlversion}/server
%dir %{moduledir}/pgxs
%attr(755,root,root) %{moduledir}/pgxs/config
%{moduledir}/pgxs/src
%files -n postgresql-static
%defattr(644,root,root,755)
%{_libdir}/libpq.a
-%{pgsqllibdir}/lib/libpgcommon.a
-%{pgsqllibdir}/lib/libpgfeutils.a
-%{pgsqllibdir}/lib/libpgport.a
+%{_libdir}/libpgcommon.a
+%{_libdir}/libpgfeutils.a
+%{_libdir}/libpgport.a
+%{_libdir}/libpgcommon_shlib.a
+%{_libdir}/libpgport_shlib.a
%files clients -f clients.lang
%defattr(644,root,root,755)
%{pgsqldatadir}/man/man7/*.7*
%if %{with perl}
-%files module-plperl -f plperl-%{pgver}.lang
+%files module-plperl -f plperl-%{pgsqlversion}.lang
%defattr(644,root,root,755)
%attr(755,root,root) %{moduledir}/plperl.so
%{extensiondir}/plperl--*.sql
%endif
%if %{with python}
-%files module-plpython -f plpython-%{pgver}.lang
+%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
%if %{with tcl}
-%files module-pltcl -f pltcl-%{pgver}.lang
+%files module-pltcl -f pltcl-%{pgsqlversion}.lang
%defattr(644,root,root,755)
%attr(755,root,root) %{moduledir}/pltcl.so
%{extensiondir}/pltcl*--*.sql
%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}/chkpass.so
%attr(755,root,root) %{moduledir}/citext.so
%attr(755,root,root) %{moduledir}/cube.so
%attr(755,root,root) %{moduledir}/earthdistance.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}/btree_gin.control
%{extensiondir}/btree_gist--*.sql
%{extensiondir}/btree_gist.control
-%{extensiondir}/chkpass--*.sql
-%{extensiondir}/chkpass.control
%{extensiondir}/citext--*.sql
%{extensiondir}/citext.control
%{extensiondir}/cube--*.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*