X-Git-Url: https://git.tld-linux.org/?a=blobdiff_plain;f=postgresql.spec;h=fa7189b5da9349addfadca9e16bf54c891099fcb;hb=4138e72c38adeb0d9c83de197164aad4139b7372;hp=3c12f7d52d483ade96accd7710abdadf5e009fb5;hpb=1d3e72d45ef3b59616f1a43e372ae4fd0cb8fdc4;p=packages%2Fpostgresql.git

diff --git a/postgresql.spec b/postgresql.spec
index 3c12f7d..fa7189b 100644
--- a/postgresql.spec
+++ b/postgresql.spec
@@ -14,8 +14,8 @@
 #
 
 %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
@@ -27,25 +27,26 @@ Summary(ru.UTF-8):	PostgreSQL - система управления базами
 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}.0
+Release:	2
 License:	BSD
 Group:		Applications/Databases
 Source0:	http://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2
-# Source0-md5:	a5fe5fdff2d6c28f65601398be0950df
+# Source0-md5:	26e85a23c6a0ef68e9755555aea31141
 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
 URL:		http://www.postgresql.org/
 BuildRequires:	autoconf >= 2.69
 BuildRequires:	automake
@@ -84,22 +85,22 @@ BuildRequires:	zlib-devel
 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:	%{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
 
@@ -108,7 +109,7 @@ BuildRoot:	%{tmpdir}/%{name}-%{version}-root-%(id -u -n)
 # 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,
@@ -172,6 +173,31 @@ PostgreSQL.
 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
@@ -184,7 +210,7 @@ Summary(tr.UTF-8):	PostgreSQL başlık dosyaları ve kitaplıklar
 Summary(uk.UTF-8):	PostgreSQL - хедери та бібліотеки програміста
 Group:		Development/Libraries
 Requires:	alternatives
-Requires:	postgresql-libs = %{version}-%{release}
+Requires:	postgresql-libs >= %{version}-%{release}
 
 %description -n postgresql-devel
 This package contains header files and libraries required to compile
@@ -199,8 +225,9 @@ aplikacji łączących się bezpośrednio z serwerem PostgreSQL.
 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
@@ -219,7 +246,9 @@ Summary(ru.UTF-8):	Клиентские программы, необходимы
 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
@@ -237,6 +266,7 @@ poleceń. Serwer znajduje się w głównym pakiecie.
 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
@@ -253,6 +283,7 @@ Summary(pl.UTF-8):	Biblioteki dzielone programu PostgreSQL
 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.
@@ -264,8 +295,10 @@ Biblioteki dzielone programu PostgreSQL.
 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.
@@ -291,8 +324,8 @@ Biblioteki dzielone programu PostgreSQL.
 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.
@@ -308,7 +341,7 @@ Summary(pt_BR.UTF-8):	Bibliotecas estáticas PostgreSQL
 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.
@@ -324,7 +357,7 @@ Summary(pt_BR.UTF-8):	Bibliotecas estáticas PostgreSQL
 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.
@@ -337,6 +370,7 @@ Summary:	PL/perl - PostgreSQL procedural language
 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:
@@ -372,6 +406,7 @@ Summary(pl.UTF-8):	PL/Python - język proceduralny bazy danych PostgreSQL
 Group:		Applications/Databases
 Requires:	%{name} = %{version}-%{release}
 %pyrequires_eq	python
+Obsoletes:	postgresql-module-plpython
 
 %description module-plpython
 From PostgreSQL documentation:
@@ -407,6 +442,7 @@ Summary(pl.UTF-8):	PL/Tcl - język proceduralny bazy danych PostgreSQL
 Group:		Applications/Databases
 Requires:	%{name} = %{version}-%{release}
 Requires:	tcl(Pgtcl)
+Obsoletes:	postgresql-module-pltcl
 
 %description module-pltcl
 From PostgreSQL documentation:
@@ -441,6 +477,7 @@ Summary:	dblink module for PostgreSQL
 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
@@ -455,6 +492,7 @@ Summary:	Large Objects module for PostgreSQL
 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
@@ -470,6 +508,7 @@ Summary:	Trigram matching for PostgreSQL
 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
@@ -484,6 +523,7 @@ Summary:	Cryptographic functions for PostgreSQL
 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.
@@ -497,6 +537,7 @@ Summary(pl.UTF-8):	Zewnętrzny moduł bezpieczeństwa PostgreSQL-a wykorzystują
 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.
@@ -509,6 +550,7 @@ Summary:	crosstab functions for PostgreSQL
 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.
@@ -522,6 +564,7 @@ Summary(pl.UTF-8):	Funkcje do obsługi XML-a dla PostgreSQL-a
 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
@@ -538,6 +581,7 @@ Summary:	Miscellaneous PostgreSQL contrib modules
 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.
@@ -576,6 +620,7 @@ 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} \
@@ -615,11 +660,10 @@ done
 
 %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}
 
@@ -638,10 +682,9 @@ for mod in %{contrib_modules}; do \
 		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
@@ -654,38 +697,42 @@ tar zxf %{SOURCE2} -C howto
 # 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
@@ -693,7 +740,7 @@ 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
@@ -711,66 +758,79 @@ if [ "$foundold" = "1" ]; then
 	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 || :
@@ -787,15 +847,9 @@ if [ $1 -eq 0 ]; then
 	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
 
@@ -804,12 +858,14 @@ update-alternatives \
 
 %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
@@ -819,12 +875,12 @@ update-alternatives \
 %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
@@ -841,11 +897,8 @@ update-alternatives \
 %{extensiondir}/plpgsql--*.sql
 %{extensiondir}/plpgsql.control
 
-%dir %{pgsqldatadir}
 %{pgsqldatadir}/*.bki
 %{pgsqldatadir}/*.sample
-%{pgsqldatadir}/*.description
-%{pgsqldatadir}/*.shdescription
 %{pgsqldatadir}/*.sql
 %{pgsqldatadir}/*.txt
 %{pgsqldatadir}/timezonesets
@@ -853,18 +906,17 @@ update-alternatives \
 
 %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*
@@ -873,22 +925,44 @@ update-alternatives \
 %{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.*.*
@@ -912,9 +986,9 @@ update-alternatives \
 %{_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
@@ -933,12 +1007,12 @@ update-alternatives \
 %{_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
@@ -947,9 +1021,11 @@ update-alternatives \
 %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)
@@ -983,7 +1059,7 @@ update-alternatives \
 %{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
@@ -993,7 +1069,7 @@ update-alternatives \
 %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
 %{extensiondir}/plpython*--*.sql
@@ -1001,7 +1077,7 @@ update-alternatives \
 %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
@@ -1054,36 +1130,41 @@ update-alternatives \
 
 %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
@@ -1093,14 +1174,16 @@ update-alternatives \
 %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
@@ -1117,6 +1200,8 @@ update-alternatives \
 %{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
@@ -1125,6 +1210,10 @@ update-alternatives \
 %{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
@@ -1135,6 +1224,8 @@ update-alternatives \
 %{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
@@ -1143,6 +1234,8 @@ update-alternatives \
 %{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
@@ -1158,14 +1251,25 @@ update-alternatives \
 %{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}/jsonb_plpython2.so
 %attr(755,root,root) %{moduledir}/ltree_plpython2.so
 %{extensiondir}/hstore_plpythonu--*.sql
 %{extensiondir}/hstore_plpythonu.control
@@ -1173,6 +1277,12 @@ update-alternatives \
 %{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
@@ -1181,5 +1291,4 @@ update-alternatives \
 %{extensiondir}/ltree_plpython3u.control
 %endif
 %{pgsqldatadir}/man/man1/oid2name.1*
-%{pgsqldatadir}/man/man1/pg_standby.1*
 %{pgsqldatadir}/man/man1/vacuumlo.1*