Accepting request 1033574 from server:database:postgresql

- Update to 15.0:
  * https://www.postgresql.org/about/news/p-2526/ 
  * https://www.postgresql.org/docs/15/release-15.html
- Move pg_upgrade from *-contrib to *-server.
- Drop support for the 9.x versioning scheme.

OBS-URL: https://build.opensuse.org/request/show/1033574
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/postgresql15?expand=0&rev=3

postgresql-15.0.tar.bz2

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:72ec74f4a7c16e684f43ea42e215497fcd4c55d028a68fb72e99e61ff40da4d6
+size 22403741

postgresql-15.0.tar.bz2.sha256

@@ -0,0 +1 @@
+72ec74f4a7c16e684f43ea42e215497fcd4c55d028a68fb72e99e61ff40da4d6  postgresql-15.0.tar.bz2

postgresql-15rc2.tar.bz2

@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:11739405e96699198733f4a0055362262c9c89f32d2e835e0b815687d700cc23
-size 22420528

postgresql-15rc2.tar.bz2.sha256

@@ -1 +0,0 @@
-11739405e96699198733f4a0055362262c9c89f32d2e835e0b815687d700cc23  postgresql-15rc2.tar.bz2

postgresql15.changes

@@ -1,3 +1,12 @@
+-------------------------------------------------------------------
+Thu Oct 13 14:03:27 UTC 2022 - Reinhard Max <max@suse.com>
+
+- Update to 15.0:
+  * https://www.postgresql.org/about/news/p-2526/ 
+  * https://www.postgresql.org/docs/15/release-15.html
+- Move pg_upgrade from *-contrib to *-server.
+- Drop support for the 9.x versioning scheme.
+
 -------------------------------------------------------------------
 Thu Oct  6 13:20:57 UTC 2022 - Reinhard Max <max@suse.com>
 

postgresql15.spec

@@ -16,16 +16,14 @@
 #
 
 
-%define pgversion 15~rc2
+%define pgversion 15.0
 %define pgmajor 15
-%define pgsuffix %pgmajor
 %define buildlibs 1
-%define tarversion 15rc2
+%define tarversion %pgversion
 %define latest_supported_llvm_ver 14
 
 ### CUT HERE ###
-%define pgname postgresql%pgsuffix
+%define pgname postgresql%pgmajor
-%define priority %pgsuffix
 %define libpq libpq5
 %define libecpg libecpg6
 %define libpq_so libpq.so.5
@@ -52,9 +50,9 @@ Name:           %pgname
 %define mini 0
 %endif
 
-# Use Python 2 for PostgreSQL 9.x on all platforms and for PostgreSQL 10 on SLE12.
+# Use Python 2 for for PostgreSQL 10 on SLE12.
 # Use Python 3 for everything else.
-%if %pgsuffix < 90 && ( 0%{?is_opensuse} || 0%{?sle_version} >= 150000 || %pgsuffix > 10 )
+%if 0%{?is_opensuse} || 0%{?sle_version} >= 150000 || %pgmajor > 10
 %define python python3
 %else
 %define python python
@@ -104,7 +102,7 @@ BuildRequires:  %libpq
 %bcond_with     systemd_notify
 %endif
 
-%if 0%{?suse_version} >= 1500 && %pgsuffix >= 11 && %pgsuffix < 90
+%if 0%{?suse_version} >= 1500 && %pgmajor >= 11
 %ifarch riscv64
 %bcond_with     llvm
 %else
@@ -121,7 +119,7 @@ BuildRequires:  %libpq
 %bcond_with     check
 %endif
 
-%if ( %pgsuffix >= 11 && %pgsuffix < 90 ) || %mini
+%if %pgmajor >= 11 || %mini
 %bcond_without server_devel
 %else
 %bcond_with server_devel
@@ -301,7 +299,7 @@ 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%pgsuffix-devel package.
+applications, see the postgresql%pgmajor-devel package.
 %endif
 
 %description %devel
@@ -317,7 +315,7 @@ 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%pgsuffix-server-devel package.
+postgresql%pgmajor-server-devel package.
 
 %package server
 Summary:        The Programs Needed to Create and Run a PostgreSQL Server
@@ -645,7 +643,7 @@ cp doc/KNOWN_BUGS doc/MISSING_FEATURES COPYRIGHT \
 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%pgsuffix
+        mv $f ${f}pg%pgmajor
 done
 %endif
 
@@ -712,6 +710,9 @@ genlists server \
 	pg_resetwal \
 	pg_waldump \
 	pg_resetxlog \
+%if %pgmajor >= 15
+	pg_upgrade \
+%endif
 	postgres \
 	postmaster
 
@@ -722,7 +723,9 @@ genlists contrib \
 	pg_amcheck \
 	pg_standby \
 	pg_test_fsync \
+%if %pgmajor < 15
 	pg_upgrade \
+%endif
         pgbench \
 	vacuumlo \
 	pg_test_timing
@@ -752,7 +755,7 @@ done
 popd
 
 mkdir -p %buildroot%pgmandir/man1
-cp -a doc/src/sgml/man1/ecpg.1 %buildroot%pgmandir/man1/ecpg.1pg%pgsuffix
+cp -a doc/src/sgml/man1/ecpg.1 %buildroot%pgmandir/man1/ecpg.1pg%pgmajor
 %find_lang ecpg-$VLANG devel.files
 ln -s %pgbindir/ecpg %buildroot%_bindir/ecpg
 
@@ -792,25 +795,25 @@ awk -v P=%buildroot '/^(%lang|[^%])/{print P $NF}' libpq.files libecpg.files | x
 %if %{with server_devel}
 %post server-devel
 %endif
-/usr/share/postgresql/install-alternatives %priority
+/usr/share/postgresql/install-alternatives %pgmajor
 
 %postun %devel
 /sbin/ldconfig
 %if %{with server_devel}
 %postun server-devel
 %endif
-/usr/share/postgresql/install-alternatives %priority
+/usr/share/postgresql/install-alternatives %pgmajor
 
 %if !%mini
 
 %postun
-/usr/share/postgresql/install-alternatives %priority
+/usr/share/postgresql/install-alternatives %pgmajor
 
 %post
-/usr/share/postgresql/install-alternatives %priority
+/usr/share/postgresql/install-alternatives %pgmajor
 
 %post server
-/usr/share/postgresql/install-alternatives %priority
+/usr/share/postgresql/install-alternatives %pgmajor
 
 %preun server
 # Stop only when we are uninstalling the currently running version
@@ -833,7 +836,7 @@ if [ "$FIRST_ARG" -eq 0 ]; then
 fi
 
 %postun server
-/usr/share/postgresql/install-alternatives %priority
+/usr/share/postgresql/install-alternatives %pgmajor
 # Restart only when we are updating the currently running version
 # or from the old packaging scheme
 test -n "$FIRST_ARG" || FIRST_ARG="$1"
@@ -857,10 +860,10 @@ if [ "$FIRST_ARG" -ge 1 ]; then
 fi
 
 %post contrib
-/usr/share/postgresql/install-alternatives %priority
+/usr/share/postgresql/install-alternatives %pgmajor
 
 %postun contrib
-/usr/share/postgresql/install-alternatives %priority
+/usr/share/postgresql/install-alternatives %pgmajor
 
 %if %buildlibs
 %post -n %libpq -p /sbin/ldconfig
@@ -907,9 +910,7 @@ fi
 %dir %pgbasedir
 %dir %pgextensiondir
 %dir %pglibdir
-%if %pgsuffix < 90
 %pglibdir/pgoutput.so
-%endif
 %pglibdir/plpgsql.so
 %pglibdir/dict_snowball.so
 %pgdatadir/tsearch_data
@@ -920,9 +921,6 @@ fi
 %if %buildlibs
 %exclude %pgdatadir/pg_service.conf.sample
 %endif
-%if %pgsuffix > 90
-%exclude %pgdatadir/*.pltcl
-%endif
 %pglibdir/*_and_*.so
 %pglibdir/euc2004_sjis2004.so
 %pglibdir/libpqwalreceiver.so
@@ -945,10 +943,6 @@ fi
 %defattr(-,root,root)
 %pgextensiondir/pltcl*
 %pglibdir/pltcl.so
-%if %pgsuffix > 90
-%pgdatadir/*.pltcl
-%pgbindir/pltcl*
-%endif
 
 %files plperl -f plperl.lang
 %defattr(-,root,root)