commit postgresql11 for openSUSE:Factory

2020-11-03 Thread root
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2020-11-03 15:59:37

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.3463 (New)


Package is "postgresql11"

Tue Nov  3 15:59:37 2020 rev:10 rq:845765 version:11.9

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2020-08-15 21:14:09.855411762 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.3463/postgresql11.changes  
2020-11-03 15:59:38.658390214 +0100
@@ -1,0 +2,6 @@
+Tue Nov  3 13:54:38 UTC 2020 - Reinhard Max 
+
+- Fix a DST problem in the test suite: postgresql-timetz.patch
+  https://postgr.es/m/16689-57701daa23b37...@postgresql.org
+
+---

New:

  postgresql-timetz.patch



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.ErzjLx/_old  2020-11-03 15:59:39.418390921 +0100
+++ /var/tmp/diff_new_pack.ErzjLx/_new  2020-11-03 15:59:39.418390921 +0100
@@ -141,6 +141,7 @@
 Patch6: postgresql-testsuite-int8.sql.patch
 Patch8: postgresql-testsuite-keep-results-file.patch
 Patch9: postgresql-var-run-socket.patch
+Patch10:postgresql-timetz.patch
 URL:https://www.postgresql.org/
 BuildRoot:  %{_tmppath}/%{name}-%{version}-build
 Provides:   postgresql = %version-%release
@@ -448,6 +449,7 @@
 %patch6
 %patch8 -p1
 %patch9
+%patch10
 touch -r tmp configure
 rm tmp
 find src/test/ -name '*.orig' -delete

++ postgresql-timetz.patch ++
From: Tom Lane 
Date: Thu, 29 Oct 2020 19:28:14 + (-0400)
Subject: Stabilize timetz test across DST transitions.
X-Git-Url: 
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff_plain;h=4a071afbd056282746a5bc9362e87f579a56402d;hp=f90149e6285aaae6b48559afce1bd638ee26c33e

Stabilize timetz test across DST transitions.

The timetz test cases I added in commit a9632830b were unintentionally
sensitive to whether or not DST is active in the PST8PDT time zone.
Thus, they'll start failing this coming weekend, as reported by
Bernhard M. Wiedemann in bug #16689.  Fortunately, DST-awareness is
not significant to the purpose of these test cases, so we can just
force them all to PDT (DST hours) to preserve stability of the
results.

Back-patch to v10, as the prior patch was.

Discussion: https://postgr.es/m/16689-57701daa23b37...@postgresql.org
---

--- src/test/regress/expected/timetz.out.orig
+++ src/test/regress/expected/timetz.out
@@ -91,45 +91,45 @@ SELECT f1 AS "Ten" FROM TIMETZ_TBL WHERE
 (12 rows)
 
 -- Check edge cases
-SELECT '23:59:59.99'::timetz;
+SELECT '23:59:59.99 PDT'::timetz;
timetz   
 
  23:59:59.99-07
 (1 row)
 
-SELECT '23:59:59.999'::timetz;  -- rounds up
+SELECT '23:59:59.999 PDT'::timetz;  -- rounds up
timetz
 -
  24:00:00-07
 (1 row)
 
-SELECT '23:59:60'::timetz;  -- rounds up
+SELECT '23:59:60 PDT'::timetz;  -- rounds up
timetz
 -
  24:00:00-07
 (1 row)
 
-SELECT '24:00:00'::timetz;  -- allowed
+SELECT '24:00:00 PDT'::timetz;  -- allowed
timetz
 -
  24:00:00-07
 (1 row)
 
-SELECT '24:00:00.01'::timetz;  -- not allowed
-ERROR:  date/time field value out of range: "24:00:00.01"
-LINE 1: SELECT '24:00:00.01'::timetz;
+SELECT '24:00:00.01 PDT'::timetz;  -- not allowed
+ERROR:  date/time field value out of range: "24:00:00.01 PDT"
+LINE 1: SELECT '24:00:00.01 PDT'::timetz;
^
-SELECT '23:59:60.01'::timetz;  -- not allowed
-ERROR:  date/time field value out of range: "23:59:60.01"
-LINE 1: SELECT '23:59:60.01'::timetz;
+SELECT '23:59:60.01 PDT'::timetz;  -- not allowed
+ERROR:  date/time field value out of range: "23:59:60.01 PDT"
+LINE 1: SELECT '23:59:60.01 PDT'::timetz;
^
-SELECT '24:01:00'::timetz;  -- not allowed
-ERROR:  date/time field value out of range: "24:01:00"
-LINE 1: SELECT '24:01:00'::timetz;
+SELECT '24:01:00 PDT'::timetz;  -- not allowed
+ERROR:  date/time field value out of range: "24:01:00 PDT"
+LINE 1: SELECT '24:01:00 PDT'::timetz;
^
-SELECT '25:00:00'::timetz;  -- not allowed
-ERROR:  date/time field value out of range: "25:00:00"
-LINE 1: SELECT '25:00:00'::timetz;
+SELECT '25:00:00 PDT'::timetz;  -- not allowed
+ERROR:  date/time field value out of range: "25:00:00 PDT"
+LINE 1: SELECT '25:00:00 PDT'::timetz;
^
 --
 -- TIME simple math
--- src/test/regress/sql/timetz.sql.orig
+++ src/test/regress/sql/timetz.sql
@@ -36,14 +36,14 @@ SELECT f1 AS "None" FROM TIMETZ_TBL WHER
 SELECT f1 AS "Ten" FROM TIMETZ_TBL WHERE f1 >= '00:00-07';
 
 -- Check edge cases
-SELECT 

commit postgresql11 for openSUSE:Factory

2020-08-15 Thread root
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2020-08-15 21:13:52

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.3399 (New)


Package is "postgresql11"

Sat Aug 15 21:13:52 2020 rev:9 rq:826607 version:11.9

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2020-06-11 09:57:55.917853751 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.3399/postgresql11.changes  
2020-08-15 21:14:09.855411762 +0200
@@ -1,0 +2,19 @@
+Thu Aug 13 14:33:16 UTC 2020 - Reinhard Max 
+
+- update to 11.9:
+  * CVE-2020-14349, bsc#1175193: Set a secure search_path in
+logical replication walsenders and apply workers
+  * CVE-2020-14350, bsc#1175194: Make contrib modules' installation
+scripts more secure.
+  * https://www.postgresql.org/docs/11/release-11-9.html
+- Remove postgresql-regress.patch, it does not apply anymore and
+  it does not seem to be needed anymore.
+- Pack the /usr/lib/postgresql symlink only into the main package.
+
+---
+Tue Jun 16 12:21:43 UTC 2020 - Reinhard Max 
+
+- Let postgresqlXX conflict with postgresql-noarch < 12.0.1 to get
+  a clean and complete cutover to the new packaging schema.
+
+---
@@ -8,0 +28,3 @@
+- Move from the "libs" build flavour to a "mini" package that will
+  only be used inside the build service and not get shipped, to
+  avoid confusion with the debuginfo packages (bsc#1148643).

Old:

  postgresql-11.8.tar.bz2
  postgresql-11.8.tar.bz2.sha256
  postgresql-regress.patch

New:

  postgresql-11.9.tar.bz2
  postgresql-11.9.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.q4oRCM/_old  2020-08-15 21:14:12.291413125 +0200
+++ /var/tmp/diff_new_pack.q4oRCM/_new  2020-08-15 21:14:12.295413127 +0200
@@ -16,7 +16,7 @@
 #
 
 
-%define pgversion 11.8
+%define pgversion 11.9
 %define pgmajor 11
 %define pgsuffix %pgmajor
 %define buildlibs 0
@@ -136,7 +136,6 @@
 Source3:postgresql-README.SUSE
 Source17:   postgresql-rpmlintrc
 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
@@ -149,6 +148,9 @@
 Requires:   %libpq >= %version
 Requires(post): postgresql-noarch >= %pgmajor
 Requires(postun): postgresql-noarch >= %pgmajor
+# At this point we changed the package layout on SLE and conflict with
+# older releases to get a clean cut.
+Conflicts:  postgresql-noarch < 12.0.1
 
 %description
 PostgreSQL is an advanced object-relational database management system
@@ -210,7 +212,12 @@
 Provides:   postgresql-devel-implementation = %version-%release
 %if %mini
 Requires:   this-is-only-for-build-envs
+Provides:   %libecpg = %version-%release
+Provides:   %libpq = %version-%release
 Provides:   %pgname-devel = %version-%release
+Conflicts:  %pgname-devel
+Conflicts:  %libecpg
+Conflicts:  %libpq
 %else
 Requires:   %libecpg >= %version
 Requires:   %libpq >= %version
@@ -437,7 +444,6 @@
 # confuse PostgreSQL's build system
 touch -r configure tmp
 %patch1
-%patch2
 %patch4
 %patch6
 %patch8 -p1
@@ -834,7 +840,6 @@
 %pgdocdir/extension
 %dir %pgdatadir
 %dir %pgcontribdir
-/usr/lib/postgresql
 
 %files server -f server.files
 %defattr(-,root,root)
@@ -849,7 +854,6 @@
 %pgdatadir/tsearch_data
 %exclude %pgdatadir/tsearch_data/*.rules
 %dir %pgdatadir
-/usr/lib/postgresql
 %pgdatadir/timezone*
 %pgdatadir/*.*
 %if %buildlibs

++ postgresql-11.8.tar.bz2 -> postgresql-11.9.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.8.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.3399/postgresql-11.9.tar.bz2 
differ: char 11, line 1

++ postgresql-11.8.tar.bz2.sha256 -> postgresql-11.9.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.8.tar.bz2.sha256  
2020-06-11 09:57:52.197841796 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.3399/postgresql-11.9.tar.bz2.sha256
2020-08-15 21:14:07.427410403 +0200
@@ -1 +1 @@
-eaf2f4329ccc349c89e950761b81daf8c99bb8966abcab5665ccd6ee95c77ae2  
postgresql-11.8.tar.bz2
+35618aa72e0372091f923c42389c6febd07513157b4fbb9408371706afbb6635  
postgresql-11.9.tar.bz2




commit postgresql11 for openSUSE:Factory

2020-06-11 Thread root
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2020-06-11 09:57:40

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.3606 (New)


Package is "postgresql11"

Thu Jun 11 09:57:40 2020 rev:8 rq:811584 version:11.8

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2020-02-19 12:40:28.607617268 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.3606/postgresql11.changes  
2020-06-11 09:57:55.917853751 +0200
@@ -1,0 +2,9 @@
+Wed Jun  3 17:35:11 UTC 2020 - Reinhard Max 
+
+- update to 11.8 (bsc#1171924).
+  https://www.postgresql.org/about/news/2038/
+  https://www.postgresql.org/docs/11/release-11-8.html
+- Unify the spec file to work across all current PostgreSQL
+  versions to simplify future maintenance.
+
+---

Old:

  _multibuild
  postgresql-11.7.tar.bz2
  postgresql-11.7.tar.bz2.sha256

New:

  postgresql-11.8.tar.bz2
  postgresql-11.8.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
 740 lines (skipped)
 between /work/SRC/openSUSE:Factory/postgresql11/postgresql11.spec
 and /work/SRC/openSUSE:Factory/.postgresql11.new.3606/postgresql11.spec

++ postgresql-11.7.tar.bz2 -> postgresql-11.8.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.7.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.3606/postgresql-11.8.tar.bz2 
differ: char 11, line 1

++ postgresql-11.7.tar.bz2.sha256 -> postgresql-11.8.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.7.tar.bz2.sha256  
2020-02-19 12:40:28.587617229 +0100
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.3606/postgresql-11.8.tar.bz2.sha256
2020-06-11 09:57:52.197841796 +0200
@@ -1 +1 @@
-324ae93a8846fbb6a25d562d271bc441ffa8794654c5b2839384834de220a313  
postgresql-11.7.tar.bz2
+eaf2f4329ccc349c89e950761b81daf8c99bb8966abcab5665ccd6ee95c77ae2  
postgresql-11.8.tar.bz2

++ postgresql-rpmlintrc ++
--- /var/tmp/diff_new_pack.3MDbkB/_old  2020-06-11 09:57:56.857856772 +0200
+++ /var/tmp/diff_new_pack.3MDbkB/_new  2020-06-11 09:57:56.861856785 +0200
@@ -5,3 +5,4 @@
 addFilter("file-not-in-%lang")
 addFilter("no-dependency-on")
 addFilter("no-soname")
+addFilter("devel-file-in-non-devel-package")

++ postgresql-testsuite-int8.sql.patch ++
--- /var/tmp/diff_new_pack.3MDbkB/_old  2020-06-11 09:57:56.869856811 +0200
+++ /var/tmp/diff_new_pack.3MDbkB/_new  2020-06-11 09:57:56.869856811 +0200
@@ -4,10 +4,8 @@
 
 + SET LC_
 
-Index: postgresql-11beta1/src/test/regress/expected/int8.out
-===
 postgresql-11beta1.orig/src/test/regress/expected/int8.out
-+++ postgresql-11beta1/src/test/regress/expected/int8.out
+--- src/test/regress/expected/int8.out.orig
 src/test/regress/expected/int8.out
 @@ -580,6 +580,7 @@ SELECT '' AS to_char_12, to_char(q2, 'FM
  | -4567890123456789.000
  (5 rows)
@@ -16,10 +14,8 @@
  SELECT '' AS to_char_13, to_char(q2, 'L.000')  FROM INT8_TBL;
   to_char_13 |to_char 
  +
-Index: postgresql-11beta1/src/test/regress/expected/numeric.out
-===
 postgresql-11beta1.orig/src/test/regress/expected/numeric.out
-+++ postgresql-11beta1/src/test/regress/expected/numeric.out
+--- src/test/regress/expected/numeric.out.orig
 src/test/regress/expected/numeric.out
 @@ -1079,6 +1079,7 @@ SELECT '' AS to_char_15, to_char(val, 'F
  | -24926804.04504742
  (10 rows)
@@ -28,10 +24,8 @@
  SELECT '' AS to_char_16, to_char(val, 'L.099')
FROM num_data;
   to_char_16 |  to_char   
  +
-Index: postgresql-11beta1/src/test/regress/sql/int8.sql
-===
 postgresql-11beta1.orig/src/test/regress/sql/int8.sql
-+++ postgresql-11beta1/src/test/regress/sql/int8.sql
+--- src/test/regress/sql/int8.sql.orig
 src/test/regress/sql/int8.sql
 @@ -116,6 +116,7 @@ SELECT '' AS to_char_9,  to_char(q2, '09
  SELECT '' AS to_char_10, to_char(q2, 'S0999')  FROM INT8_TBL;
  SELECT '' AS to_char_11, to_char(q2, 'FM0999') FROM INT8_TBL;
@@ -40,10 +34,8 @@
  SELECT '' AS to_char_13, to_char(q2, 'L.000')  FROM INT8_TBL;
  SELECT '' AS to_char_14, to_char(q2, 'FM.999') FROM INT8_TBL;
  SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 

commit postgresql11 for openSUSE:Factory

2020-02-19 Thread root
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2020-02-19 12:40:21

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.26092 (New)


Package is "postgresql11"

Wed Feb 19 12:40:21 2020 rev:7 rq:774448 version:11.7

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2020-02-03 11:11:33.789791705 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.26092/postgresql11.changes 
2020-02-19 12:40:28.607617268 +0100
@@ -1,0 +2,7 @@
+Sat Feb 15 03:10:12 UTC 2020 - Marcus Rueckert 
+
+- update to 11.7: (CVE-2020-1720) 
+  https://www.postgresql.org/about/news/2011/
+  https://www.postgresql.org/docs/11/release-11-7.html
+
+---

Old:

  postgresql-11.6.tar.bz2
  postgresql-11.6.tar.bz2.sha256

New:

  postgresql-11.7.tar.bz2
  postgresql-11.7.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.FKE0U3/_old  2020-02-19 12:40:29.279618562 +0100
+++ /var/tmp/diff_new_pack.FKE0U3/_new  2020-02-19 12:40:29.283618569 +0100
@@ -1,7 +1,7 @@
 #
 # spec file for package postgresql11
 #
-# Copyright (c) 2019 SUSE LINUX GmbH, Nuernberg, Germany.
+# 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
@@ -112,7 +112,7 @@
 Summary:Basic Clients and Utilities for PostgreSQL
 License:PostgreSQL
 Group:  Productivity/Databases/Tools
-Version:11.6
+Version:11.7
 Release:0
 Source0:
https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2
 Source1:
https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2.sha256
@@ -126,7 +126,7 @@
 Patch6: postgresql-testsuite-int8.sql.patch
 Patch8: postgresql-testsuite-keep-results-file.patch
 Patch9: postgresql-var-run-socket.patch
-Url:https://www.postgresql.org/
+URL:https://www.postgresql.org/
 BuildRoot:  %{_tmppath}/%{name}-%{version}-build
 Provides:   postgresql = %version-%release
 Provides:   postgresql-implementation = %version-%release

++ postgresql-11.6.tar.bz2 -> postgresql-11.7.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.6.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.26092/postgresql-11.7.tar.bz2 
differ: char 11, line 1

++ postgresql-11.6.tar.bz2.sha256 -> postgresql-11.7.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.6.tar.bz2.sha256  
2020-01-28 10:46:06.288457424 +0100
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.26092/postgresql-11.7.tar.bz2.sha256
   2020-02-19 12:40:28.587617229 +0100
@@ -1 +1 @@
-49924f7ff92965fdb20c86e0696f2dc9f8553e1563124ead7beedf8910c13170  
postgresql-11.6.tar.bz2
+324ae93a8846fbb6a25d562d271bc441ffa8794654c5b2839384834de220a313  
postgresql-11.7.tar.bz2




commit postgresql11 for openSUSE:Factory

2020-02-03 Thread root
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2020-02-03 11:11:15

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.26092 (New)


Package is "postgresql11"

Mon Feb  3 11:11:15 2020 rev:6 rq:768273 version:11.6

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2020-01-28 10:46:06.328457448 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.26092/postgresql11.changes 
2020-02-03 11:11:33.789791705 +0100
@@ -1,0 +2,6 @@
+Mon Jan 27 09:10:34 UTC 2020 - Guillaume GARDET 
+
+- Disable explicitly armv8 CRC for %arm, as we use some armv8
+  workers for armv6/7 builds which is confusing configure script
+
+---



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.7IsKPT/_old  2020-02-03 11:11:36.529793090 +0100
+++ /var/tmp/diff_new_pack.7IsKPT/_new  2020-02-03 11:11:36.529793090 +0100
@@ -435,6 +435,9 @@
 %build
 %global _lto_cflags %{_lto_cflags} -ffat-lto-objects
 export PYTHON=python3
+%ifarch %arm
+export USE_ARMV8_CRC32C=0
+%endif
 PACKAGE_TARNAME=%pgname %configure \
 --bindir=%pgbindir \
 --libdir=%pglibdir \




commit postgresql11 for openSUSE:Factory

2020-01-28 Thread root
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2020-01-28 10:45:53

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.26092 (New)


Package is "postgresql11"

Tue Jan 28 10:45:53 2020 rev:5 rq:766658 version:11.6

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2019-09-05 12:29:42.239627544 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.26092/postgresql11.changes 
2020-01-28 10:46:06.328457448 +0100
@@ -1,0 +2,19 @@
+Fri Dec 20 14:58:51 UTC 2019 - Marcus Rueckert 
+
+- update to 11.6:
+  https://www.postgresql.org/about/news/1994/
+  https://www.postgresql.org/docs/11/release-11-6.html
+
+---
+Tue Oct 22 16:56:44 UTC 2019 - Marcus Rueckert 
+
+- add requires to the server-devel package for the libs that are
+  returned by pg_config --libs
+
+---
+Tue Oct 22 12:22:35 UTC 2019 - Marcus Rueckert 
+
+- disable building of the libraries here. Will now be provided from
+  the 12.0 package
+
+---

Old:

  postgresql-11.5.tar.bz2
  postgresql-11.5.tar.bz2.sha256

New:

  postgresql-11.6.tar.bz2
  postgresql-11.6.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.eld7Ot/_old  2020-01-28 10:46:08.844458994 +0100
+++ /var/tmp/diff_new_pack.eld7Ot/_new  2020-01-28 10:46:08.880459015 +0100
@@ -58,7 +58,7 @@
 %if "@BUILD_FLAVOR@" == "libs"
 Name:   %pgname-libs
 %define buildmain 0
-%define buildlibs 1
+%define buildlibs 0
 %define builddevel 1
 %else
 Name:   %pgname
@@ -112,7 +112,7 @@
 Summary:Basic Clients and Utilities for PostgreSQL
 License:PostgreSQL
 Group:  Productivity/Databases/Tools
-Version:11.5
+Version:11.6
 Release:0
 Source0:
https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2
 Source1:
https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2.sha256
@@ -259,6 +259,19 @@
 %if %{with llvm}
 Requires:   clang-devel
 %endif
+Requires:   libxslt-devel
+Requires:   openssl-devel
+Requires:   pam-devel
+Requires:   readline-devel
+Requires:   zlib-devel
+%if 0%{?suse_version} == 1110
+Requires:   krb5-devel
+%else
+Requires:   pkgconfig(krb5)
+%endif
+%if %{with selinux}
+Requires:   libselinux-devel
+%endif
 
 %description server-devel
 PostgreSQL is an advanced object-relational database management system

++ postgresql-11.5.tar.bz2 -> postgresql-11.6.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.5.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.26092/postgresql-11.6.tar.bz2 
differ: char 11, line 1

++ postgresql-11.5.tar.bz2.sha256 -> postgresql-11.6.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.5.tar.bz2.sha256  
2019-09-05 12:29:42.211627549 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.26092/postgresql-11.6.tar.bz2.sha256
   2020-01-28 10:46:06.288457424 +0100
@@ -1 +1 @@
-7fdf23060bfc715144cbf2696cf05b0fa284ad3eb21f0c378591c6bca99ad180  
postgresql-11.5.tar.bz2
+49924f7ff92965fdb20c86e0696f2dc9f8553e1563124ead7beedf8910c13170  
postgresql-11.6.tar.bz2




commit postgresql11 for openSUSE:Factory

2019-09-05 Thread root
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2019-09-05 12:29:40

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.7948 (New)


Package is "postgresql11"

Thu Sep  5 12:29:40 2019 rev:4 rq:723108 version:11.5

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2019-07-13 14:00:09.882902269 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.7948/postgresql11.changes  
2019-09-05 12:29:42.239627544 +0200
@@ -1,0 +2,16 @@
+Mon Aug 12 13:20:15 UTC 2019 - Reinhard Max 
+
+- Update to 11.5:
+  * https://www.postgresql.org/about/news/1960/
+  * https://www.postgresql.org/docs/11/release-11-5.html
+  * CVE-2019-10208, bsc#1145092: TYPE in pg_temp executes arbitrary
+SQL during SECURITY DEFINER execution.
+  * CVE-2019-10209, bsc#1145091: Memory disclosure in cross-type
+comparison for hashed subplan.
+
+---
+Fri Aug  2 08:54:10 UTC 2019 - Martin Liška 
+
+- Use FAT LTO objects in order to provide proper static library.
+
+---

Old:

  postgresql-11.4.tar.bz2
  postgresql-11.4.tar.bz2.sha256

New:

  postgresql-11.5.tar.bz2
  postgresql-11.5.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.Sn6GsP/_old  2019-09-05 12:29:42.991627396 +0200
+++ /var/tmp/diff_new_pack.Sn6GsP/_new  2019-09-05 12:29:42.995627395 +0200
@@ -112,7 +112,7 @@
 Summary:Basic Clients and Utilities for PostgreSQL
 License:PostgreSQL
 Group:  Productivity/Databases/Tools
-Version:11.4
+Version:11.5
 Release:0
 Source0:
https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2
 Source1:
https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2.sha256
@@ -420,6 +420,7 @@
 find -name .gitignore -delete
 
 %build
+%global _lto_cflags %{_lto_cflags} -ffat-lto-objects
 export PYTHON=python3
 PACKAGE_TARNAME=%pgname %configure \
 --bindir=%pgbindir \

++ postgresql-11.4.tar.bz2 -> postgresql-11.5.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.4.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.7948/postgresql-11.5.tar.bz2 
differ: char 11, line 1

++ postgresql-11.4.tar.bz2.sha256 -> postgresql-11.5.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.4.tar.bz2.sha256  
2019-07-13 14:00:09.870902272 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.7948/postgresql-11.5.tar.bz2.sha256
2019-09-05 12:29:42.211627549 +0200
@@ -1 +1 @@
-02802ddffd1590805beddd1e464dd28a46a41a5f1e1df04bab4f46663195cc8b  
postgresql-11.4.tar.bz2
+7fdf23060bfc715144cbf2696cf05b0fa284ad3eb21f0c378591c6bca99ad180  
postgresql-11.5.tar.bz2

++ postgresql-var-run-socket.patch ++
--- /var/tmp/diff_new_pack.Sn6GsP/_old  2019-09-05 12:29:43.087627377 +0200
+++ /var/tmp/diff_new_pack.Sn6GsP/_new  2019-09-05 12:29:43.087627377 +0200
@@ -15,7 +15,7 @@
 
 --- src/bin/pg_upgrade/test.sh.orig
 +++ src/bin/pg_upgrade/test.sh
-@@ -150,6 +150,12 @@ done
+@@ -163,6 +163,12 @@ done
  EXTRA_REGRESS_OPTS="$EXTRA_REGRESS_OPTS --port=$PGPORT"
  export EXTRA_REGRESS_OPTS
  
@@ -25,8 +25,8 @@
 +
 +POSTMASTER_OPTS="$POSTMASTER_OPTS -c unix_socket_directories='$PGHOST'"
 +
- # enable echo so the user can see what is being executed
- set -x
+ standard_initdb "$oldbindir"/initdb
+ "$oldbindir"/pg_ctl start -l "$logdir/postmaster1.log" -o "$POSTMASTER_OPTS" 
-w
  
 --- src/backend/utils/misc/guc.c.orig
 +++ src/backend/utils/misc/guc.c
@@ -41,7 +41,7 @@
  #endif
 --- src/bin/initdb/initdb.c.orig
 +++ src/bin/initdb/initdb.c
-@@ -1105,7 +1105,7 @@ setup_config(void)
+@@ -1110,7 +1110,7 @@ setup_config(void)
  
  #ifdef HAVE_UNIX_SOCKETS
snprintf(repltok, sizeof(repltok), "#unix_socket_directories = '%s'",




commit postgresql11 for openSUSE:Factory

2019-07-13 Thread root
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2019-07-13 13:46:22

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.4615 (New)


Package is "postgresql11"

Sat Jul 13 13:46:22 2019 rev:3 rq:713375 version:11.4

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2019-05-16 21:58:43.770818807 +0200
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.4615/postgresql11.changes  
2019-07-13 14:00:09.882902269 +0200
@@ -1,0 +2,9 @@
+Fri Jun 21 13:27:15 UTC 2019 - Marcus Rueckert 
+
+- update to 11.4:
+  * https://www.postgresql.org/docs/11/release-11-4.html
+  * https://www.postgresql.org/about/news/1949/
+  * CVE-2019-10164 bsc#1138034: Stack-based buffer overflow via
+setting a password
+
+---

Old:

  postgresql-11.3.tar.bz2
  postgresql-11.3.tar.bz2.sha256

New:

  postgresql-11.4.tar.bz2
  postgresql-11.4.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.rM86zH/_old  2019-07-13 14:00:10.974901935 +0200
+++ /var/tmp/diff_new_pack.rM86zH/_new  2019-07-13 14:00:10.978901933 +0200
@@ -112,7 +112,7 @@
 Summary:Basic Clients and Utilities for PostgreSQL
 License:PostgreSQL
 Group:  Productivity/Databases/Tools
-Version:11.3
+Version:11.4
 Release:0
 Source0:
https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2
 Source1:
https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2.sha256

++ postgresql-11.3.tar.bz2 -> postgresql-11.4.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.3.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.4615/postgresql-11.4.tar.bz2 
differ: char 11, line 1

++ postgresql-11.3.tar.bz2.sha256 -> postgresql-11.4.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.3.tar.bz2.sha256  
2019-05-16 21:58:43.750818815 +0200
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.4615/postgresql-11.4.tar.bz2.sha256
2019-07-13 14:00:09.870902272 +0200
@@ -1 +1 @@
-2a85e082fc225944821dfd23990e32dfcd2284c19060864b0ad4ca537d30522d  
postgresql-11.3.tar.bz2
+02802ddffd1590805beddd1e464dd28a46a41a5f1e1df04bab4f46663195cc8b  
postgresql-11.4.tar.bz2




commit postgresql11 for openSUSE:Factory

2019-05-16 Thread root
Hello community,

here is the log from the commit of package postgresql11 for openSUSE:Factory 
checked in at 2019-05-16 21:58:32

Comparing /work/SRC/openSUSE:Factory/postgresql11 (Old)
 and  /work/SRC/openSUSE:Factory/.postgresql11.new.5148 (New)


Package is "postgresql11"

Thu May 16 21:58:32 2019 rev:2 rq:702689 version:11.3

Changes:

--- /work/SRC/openSUSE:Factory/postgresql11/postgresql11.changes
2019-03-12 09:49:01.667590530 +0100
+++ /work/SRC/openSUSE:Factory/.postgresql11.new.5148/postgresql11.changes  
2019-05-16 21:58:43.770818807 +0200
@@ -1,0 +2,11 @@
+Fri May 10 09:52:48 UTC 2019 - Reinhard Max 
+
+- Update to 11.3:
+  * https://www.postgresql.org/docs/11/release-11-3.html
+  * https://www.postgresql.org/about/news/1939/
+  * CVE-2019-10130, bsc#1134689: Prevent row-level security
+policies from being bypassed via selectivity estimators.
+  * CVE-2019-10129, bsc#1134684: Avoid access to already-freed
+memory during partition routing error reports.
+
+---

Old:

  postgresql-11.2.tar.bz2
  postgresql-11.2.tar.bz2.sha256

New:

  postgresql-11.3.tar.bz2
  postgresql-11.3.tar.bz2.sha256



Other differences:
--
++ postgresql11.spec ++
--- /var/tmp/diff_new_pack.KgQKJq/_old  2019-05-16 21:58:44.774818367 +0200
+++ /var/tmp/diff_new_pack.KgQKJq/_new  2019-05-16 21:58:44.774818367 +0200
@@ -1,7 +1,7 @@
 #
-# spec file for package postgresql10
+# spec file for package postgresql11
 #
-# Copyright (c) 2018 SUSE LINUX GmbH, Nuernberg, Germany.
+# Copyright (c) 2019 SUSE LINUX GmbH, Nuernberg, Germany.
 #
 # All modifications and additions to the file contributed by third parties
 # remain the property of their copyright owners, unless otherwise agreed
@@ -12,7 +12,7 @@
 # license that conforms to the Open Source Definition (Version 1.9)
 # published by the Open Source Initiative.
 
-# Please submit bugfixes or comments via http://bugs.opensuse.org/
+# Please submit bugfixes or comments via https://bugs.opensuse.org/
 #
 
 
@@ -67,8 +67,8 @@
 %define builddevel 0
 %endif
 
-
 %if %buildmain
+BuildRequires:  docbook_4
 BuildRequires:  gettext-devel
 BuildRequires:  libuuid-devel
 BuildRequires:  ncurses-devel
@@ -78,7 +78,6 @@
 BuildRequires:  tcl-devel
 BuildRequires:  timezone
 BuildRequires:  zlib-devel
-BuildRequires:  docbook_4
 # 
 %endif
 
@@ -90,9 +89,9 @@
 BuildRequires:  libselinux-devel
 %endif
 %if %{with llvm}
-BuildRequires:  llvm-devel
 BuildRequires:  clang-devel
 BuildRequires:  gcc-c++
+BuildRequires:  llvm-devel
 %endif
 BuildRequires:  libxslt-devel
 BuildRequires:  openldap2-devel
@@ -113,7 +112,7 @@
 Summary:Basic Clients and Utilities for PostgreSQL
 License:PostgreSQL
 Group:  Productivity/Databases/Tools
-Version:11.2
+Version:11.3
 Release:0
 Source0:
https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2
 Source1:
https://ftp.postgresql.org/pub/source/v%{version}/postgresql-%{version}.tar.bz2.sha256
@@ -248,8 +247,8 @@
 %package server-devel
 Summary:PostgreSQL server development header files and utilities
 Group:  Development/Libraries/C and C++
-Provides:   postgresql-server-devel-implementation = %version-%release
 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

++ postgresql-11.2.tar.bz2 -> postgresql-11.3.tar.bz2 ++
/work/SRC/openSUSE:Factory/postgresql11/postgresql-11.2.tar.bz2 
/work/SRC/openSUSE:Factory/.postgresql11.new.5148/postgresql-11.3.tar.bz2 
differ: char 11, line 1

++ postgresql-11.2.tar.bz2.sha256 -> postgresql-11.3.tar.bz2.sha256 ++
--- /work/SRC/openSUSE:Factory/postgresql11/postgresql-11.2.tar.bz2.sha256  
2019-03-12 09:49:01.463590571 +0100
+++ 
/work/SRC/openSUSE:Factory/.postgresql11.new.5148/postgresql-11.3.tar.bz2.sha256
2019-05-16 21:58:43.750818815 +0200
@@ -1 +1 @@
-2676b9ce09c21978032070b6794696e0aa5a476e3d21d60afc036dc0a9c09405  
postgresql-11.2.tar.bz2
+2a85e082fc225944821dfd23990e32dfcd2284c19060864b0ad4ca537d30522d  
postgresql-11.3.tar.bz2