Accepting request 20456 from server:database:postgresql

Copy from server:database:postgresql/postgresql based on submit request 20456 from user rmax

OBS-URL: https://build.opensuse.org/request/show/20456
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/postgresql?expand=0&rev=14

postgresql-8.4.0.tar.bz2

@@ -1,3 +0,0 @@
-version https://git-lfs.github.com/spec/v1
-oid sha256:84bf53b4a45db4fdf875bb03bf247f29dcb97f8bda42839b00b73671df05e007
-size 13839282

postgresql-8.4.1.tar.bz2

@@ -0,0 +1,3 @@
+version https://git-lfs.github.com/spec/v1
+oid sha256:85f5a5053aea196a2c997785cb5f61368aa46407527de820006d04b594fd9d7c
+size 13579302

postgresql-conf.patch

@@ -1,6 +1,6 @@
---- ../postgresql-8.3.0.orig/src/backend/utils/misc/postgresql.conf.sample	2008-01-30 13:35:55.000000000 -0500
+--- src/backend/utils/misc/postgresql.conf.sample
-+++ src/backend/utils/misc/postgresql.conf.sample	2008-02-11 12:05:51.000000000 -0500
++++ src/backend/utils/misc/postgresql.conf.sample
-@@ -231,13 +231,13 @@
+@@ -230,13 +230,13 @@
  
  # - Where to Log -
  
@@ -16,16 +16,16 @@
  					# into log files. Required to be on for
  					# csvlogs.
  					# (change requires restart)
-@@ -313,7 +313,7 @@
+@@ -264,7 +264,7 @@
- 					# and their durations, > 0 logs only
+ #syslog_facility = 'LOCAL0'
- 					# statements running at least this time.
+ #syslog_ident = 'postgres'
  
--#silent_mode = off			# DO NOT USE without syslog or
+-#silent_mode = off			# Run server silently.
-+silent_mode = on			# DO NOT USE without syslog or
++silent_mode = on			# Run server silently.
+ 					# DO NOT USE without syslog or
  					# logging_collector
  					# (change requires restart)
- 
+@@ -330,7 +330,7 @@
-@@ -328,7 +328,7 @@
  #log_disconnections = off
  #log_duration = off
  #log_hostname = off

postgresql-pl.spec

@@ -1,5 +1,5 @@
 #
-# spec file for package postgresql-pl (Version 8.4.0)
+# spec file for package postgresql-pl (Version 8.4.1)
 #
 # Copyright (c) 2009 SUSE LINUX Products GmbH, Nuernberg, Germany.
 #
@@ -23,7 +23,7 @@ BuildRequires:  openldap2-devel openssl-devel pam-devel readline-devel
 BuildRequires:  ncurses-devel
 BuildRequires:  python-devel tcl-devel
 Summary:        The PL/Tcl, PL/Perl, and PL/Python Procedural Languages for PostgreSQL
-Version:        8.4.0
+Version:        8.4.1
 Release:        1
 %define pg_minor_version %(echo %version | cut -f1-2 -d.)
 License:        BSD 3-clause (or similar)

postgresql.changes

@@ -1,3 +1,81 @@
+-------------------------------------------------------------------
+Thu Sep 10 12:06:36 CEST 2009 - max@suse.de
+
+- Security and bugfix release 8.4.1:
+
+  * Fix WAL page header initialization at the end of archive
+    recovery. This could lead to failure to process the WAL in a
+    subsequent archive recovery.
+  * Fix "cannot make new WAL entries during recovery" error.
+  * Fix problem that could make expired rows visible after a crash.
+    This bug involved a page status bit potentially not being set
+    correctly after a server crash.
+  * Disallow RESET ROLE and RESET SESSION AUTHORIZATION inside
+    security-definer functions. This covers a case that was missed
+    in the previous patch that disallowed SET ROLE and SET SESSION
+    AUTHORIZATION inside security-definer functions.
+    (See CVE-2007-6600)
+  * Make LOAD of an already-loaded loadable module into a no-op.
+  * Formerly, LOAD would attempt to unload and re-load the module,
+    but this is unsafe and not all that useful.
+  * Make window function PARTITION BY and ORDER BY items always be
+    interpreted as simple expressions. In 8.4.0 these lists were
+    parsed following the rules used for top-level GROUP BY and
+    ORDER BY lists. But this was not correct per the SQL standard,
+    and it led to possible circularity.
+  * Fix several errors in planning of semi-joins.  These led to
+    wrong query results in some cases where IN or EXISTS was used
+    together with another join.
+  * Fix handling of whole-row references to subqueries that are
+    within an outer join. An example is SELECT COUNT(ss.*) FROM
+    ... LEFT JOIN (SELECT ...) ss ON .... Here, ss.* would be
+    treated as ROW(NULL,NULL,...) for null-extended join rows,
+    which is not the same as a simple NULL. Now it is treated as a
+    simple NULL.
+  * Fix Windows shared-memory allocation code.  This bug led to the
+    often-reported "could not reattach to shared memory" error
+    message.
+  * Fix locale handling with plperl.
+    This bug could cause the server's locale setting to change when
+    a plperl function is called, leading to data corruption.
+  * Fix handling of reloptions to ensure setting one option doesn't
+    force default values for others.
+  * Ensure that a "fast shutdown" request will forcibly terminate
+    open sessions, even if a "smart shutdown" was already in
+    progress.
+  * Avoid memory leak for array_agg() in GROUP BY queries.
+  * Treat to_char(..., 'TH') as an uppercase ordinal suffix with
+   'HH'/'HH12'. It was previously handled as 'th' (lowercase).
+  * Include the fractional part in the result of EXTRACT(second)
+    and EXTRACT(milliseconds) for time and time with time zone
+    inputs.
+    This has always worked for floating-point datetime
+    configurations, but was broken in the integer datetime code.
+  * Fix overflow for INTERVAL 'x ms' when x is more than 2 million
+    and integer datetimes are in use.
+  * Improve performance when processing toasted values in index
+    scans. This is particularly useful for PostGIS.
+  * Fix a typo that disabled commit_delay.
+  * Output early-startup messages to postmaster.log if the server
+    is started in silent mode.  Previously such error messages were
+    discarded, leading to difficulty in debugging.
+  * Remove translated FAQs. They are now on the wiki. The main FAQ
+    was moved to the wiki some time ago.
+  * Fix pg_ctl to not go into an infinite loop if postgresql.conf
+    is empty.
+  * Fix several errors in pg_dump's --binary-upgrade mode.
+  * pg_dump --binary-upgrade is used by pg_migrator.
+  * Fix contrib/xml2's xslt_process() to properly handle the
+    maximum number of parameters (twenty).
+  * Improve robustness of libpq's code to recover from errors
+    during COPY FROM STDIN.
+
+  * Avoid including conflicting readline and editline header files
+    when both libraries are installed.
+
+  * Work around gcc bug that causes "floating-point exception"
+    instead of "division by zero" on some platforms.
+
 -------------------------------------------------------------------
 Mon Jul 27 20:24:35 CEST 2009 - poeml@suse.de
 

postgresql.spec

@@ -1,5 +1,5 @@
 #
-# spec file for package postgresql (Version 8.4.0)
+# spec file for package postgresql (Version 8.4.1)
 #
 # Copyright (c) 2009 SUSE LINUX Products GmbH, Nuernberg, Germany.
 #
@@ -15,6 +15,7 @@
 # Please submit bugfixes or comments via http://bugs.opensuse.org/
 #
 
+# norootforbuild
 
 
 Name:           postgresql
@@ -22,7 +23,7 @@ BuildRequires:  bison flex gettext-devel krb5-devel libxslt-devel
 BuildRequires:  openldap2-devel openssl-devel pam-devel readline-devel zlib-devel
 BuildRequires:  ncurses-devel
 Summary:        Basic Clients and Utilities for PostgreSQL
-Version:        8.4.0
+Version:        8.4.1
 Release:        1
 %define pg_minor_version %(echo %version | cut -f1-2 -d.)
 License:        BSD 3-clause (or similar)
@@ -36,9 +37,9 @@ Source15:       postgresql-bashprofile
 Source16:       postgresql-firewall
 Source17:       postgresql-rpmlintrc
 Source99:       postgresql-pl.spec
-Patch1:         postgresql-8.3-conf.patch
+Patch1:         postgresql-conf.patch
 Patch2:         postgresql-regress.patch
-Patch3:         postgresql-8.4.0-sle10-timestamptz.patch
+Patch3:         postgresql-sle10-timestamptz.patch
 PreReq:         postgresql-libs = %pg_minor_version
 Url:            http://www.postgresql.org/
 Provides:       postgresql = %pg_minor_version
@@ -259,12 +260,11 @@ make %{?jobs:-j%jobs} -C contrib all
 # Run the regression tests.
 #
 make check || {
-  for f in log/* regression.diffs; do
+  for f in src/test/regress/log/* regression.diffs; do
     if test -f $f; then
-        echo ==== $f ====================
+	cat $f
     fi
   done
-  echo ==============================
   exit 1
 }
 %endif
@@ -299,7 +299,7 @@ sed 's,@LIBDIR@,%_libdir,g' %{SOURCE15} > \
 	%buildroot/var/lib/pgsql/.bash_profile
 # Backup directory for old version binaries
 install -d %buildroot%_libdir/postgresql/backup
-cp doc/FAQ* doc/KNOWN_BUGS doc/MISSING_FEATURES doc/README* COPYRIGHT \
+cp doc/KNOWN_BUGS doc/MISSING_FEATURES doc/README* COPYRIGHT \
    README HISTORY doc/bug.template %buildroot%_docdir/postgresql
 cp -a %SOURCE2 %buildroot%_docdir/postgresql/README.SuSE.de
 cp -a %SOURCE3 %buildroot%_docdir/postgresql/README.SuSE.en