Hello community,
here is the log from the commit of package postgresql for openSUSE:Factory
checked in at Wed Jul 29 17:16:55 CEST 2009.
--------
--- postgresql/postgresql.changes 2009-05-06 17:59:50.000000000 +0200
+++ /mounts/work_src_done/STABLE/postgresql/postgresql.changes 2009-07-27 20:27:56.000000000 +0200
@@ -1,0 +2,46 @@
+Mon Jul 27 20:24:35 CEST 2009 - poeml@suse.de
+
+- postgresql-8.4.0-sle10-timestamptz.patch added, and applied
+ _only_ on SLE10. It fixes a build failure due to a test case that
+ seems to be confused by daylight saving time in the time zone
+ that the test expects its result (PDT vs. PST). Since this
+ failure happened only on SLE10, I assume that the test case isn't
+ broken, and some peculiarity on that (rather old now) platform is
+ to blame (possibly too old timezone files). Also, the testcase is
+ checking correctness when converting timezones > 32 bit, which
+ actually seems to work.
+
+-------------------------------------------------------------------
+Wed Jul 15 21:10:36 CEST 2009 - poeml@suse.de
+
+- replace "ident sameuser" with "ident" as auth method for the
+ initdb call in the init script, because the former doesn't work
+ with PostgreSQL 8.4. With the generated pg_hba.conf, PostgreSQL
+ failed to start. Added note to the upgrade READMEs. [bnc#522375]
+
+-------------------------------------------------------------------
+Tue Jul 7 15:56:49 CEST 2009 - max@suse.de
+
+- New major release: 8.4.0
+- Improvements include:
+ * Windowing Functions
+ * Common Table Expressions and Recursive Queries
+ * Default and variadic parameters for functions
+ * Parallel Restore
+ * Column Permissions
+ * Per-database locale settings
+ * Improved hash indexes
+ * Improved join performance for EXISTS and NOT EXISTS queries
+ * Easier-to-use Warm Standby
+ * Automatic sizing of the Free Space Map
+ * Visibility Map (greatly reduces vacuum overhead for
+ slowly-changing tables)
+ * Version-aware psql (backslash commands work against older
+ servers)
+ * Support SSL certificates for user authentication
+ * Per-function runtime statistics
+ * Easy editing of functions in psql
+ * New contrib modules: pg_stat_statements, auto_explain, citext,
+ btree_gin
+
+-------------------------------------------------------------------
calling whatdependson for head-i586
Old:
----
postgresql-8.3.7.tar.bz2
New:
----
postgresql-8.4.0-sle10-timestamptz.patch
postgresql-8.4.0.tar.bz2
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Other differences:
------------------
++++++ postgresql-pl.spec ++++++
--- /var/tmp/diff_new_pack.nMwP2a/_old 2009-07-29 17:15:41.000000000 +0200
+++ /var/tmp/diff_new_pack.nMwP2a/_new 2009-07-29 17:15:41.000000000 +0200
@@ -1,5 +1,5 @@
#
-# spec file for package postgresql-pl (Version 8.3.7)
+# spec file for package postgresql-pl (Version 8.4.0)
#
# Copyright (c) 2009 SUSE LINUX Products GmbH, Nuernberg, Germany.
#
@@ -23,10 +23,10 @@
BuildRequires: ncurses-devel
BuildRequires: python-devel tcl-devel
Summary: The PL/Tcl, PL/Perl, and PL/Python Procedural Languages for PostgreSQL
-Version: 8.3.7
+Version: 8.4.0
Release: 1
%define pg_minor_version %(echo %version | cut -f1-2 -d.)
-License: BSD 3-Clause
+License: BSD 3-clause (or similar)
Group: Productivity/Databases/Servers
Source0: postgresql-%version.tar.bz2
NoSource: 0
@@ -59,7 +59,7 @@
Jan Wieck
%package -n postgresql-plperl
-License: BSD 3-Clause
+License: BSD 3-clause (or similar)
Summary: The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL
Group: Productivity/Databases/Servers
Requires: perl
@@ -87,7 +87,7 @@
etc.
%package -n postgresql-plpython
-License: BSD 3-Clause
+License: BSD 3-clause (or similar)
Summary: The PL/Python Procedural Languages for PostgreSQL
Group: Productivity/Databases/Servers
Obsoletes: postgresql-pl
@@ -119,7 +119,7 @@
Jan Wieck
%package -n postgresql-pltcl
-License: BSD 3-Clause
+License: BSD 3-clause (or similar)
Summary: PL/Tcl Procedural Language for PostgreSQL
Group: Productivity/Databases/Tools
Obsoletes: postgresql-pl
@@ -201,15 +201,18 @@
%_libdir/postgresql/pltcl.so
%_datadir/postgresql
%_bindir/pltcl*
+%_datadir/locale/*/*/pltcl-*.mo
%files -n postgresql-plperl
%defattr(-,root,root)
%dir %_libdir/postgresql
%_libdir/postgresql/plperl.so
+%_datadir/locale/*/*/plperl-*.mo
%files -n postgresql-plpython
%defattr(-,root,root)
%dir %_libdir/postgresql
%_libdir/postgresql/plpython.so
+%_datadir/locale/*/*/plpython-*.mo
%changelog
++++++ postgresql.spec ++++++
--- /var/tmp/diff_new_pack.nMwP2a/_old 2009-07-29 17:15:41.000000000 +0200
+++ /var/tmp/diff_new_pack.nMwP2a/_new 2009-07-29 17:15:41.000000000 +0200
@@ -1,5 +1,5 @@
#
-# spec file for package postgresql (Version 8.3.7)
+# spec file for package postgresql (Version 8.4.0)
#
# Copyright (c) 2009 SUSE LINUX Products GmbH, Nuernberg, Germany.
#
@@ -22,10 +22,10 @@
BuildRequires: openldap2-devel openssl-devel pam-devel readline-devel zlib-devel
BuildRequires: ncurses-devel
Summary: Basic Clients and Utilities for PostgreSQL
-Version: 8.3.7
+Version: 8.4.0
Release: 1
%define pg_minor_version %(echo %version | cut -f1-2 -d.)
-License: BSD 3-Clause
+License: BSD 3-clause (or similar)
Group: Productivity/Databases/Tools
Source0: postgresql-%version.tar.bz2
Source2: postgresql-README.SuSE.de
@@ -38,6 +38,7 @@
Source99: postgresql-pl.spec
Patch1: postgresql-8.3-conf.patch
Patch2: postgresql-regress.patch
+Patch3: postgresql-8.4.0-sle10-timestamptz.patch
PreReq: postgresql-libs = %pg_minor_version
Url: http://www.postgresql.org/
Provides: postgresql = %pg_minor_version
@@ -66,7 +67,7 @@
Jan Wieck
%package libs
-License: BSD 3-Clause
+License: BSD 3-clause (or similar)
Summary: Shared Libraries Required for PostgreSQL Clients
Group: Productivity/Databases/Clients
# bug437293
@@ -99,7 +100,7 @@
Jan Wieck
%package server
-License: BSD 3-Clause
+License: BSD 3-clause (or similar)
Summary: The Programs Needed to Create and Run a PostgreSQL Server
Group: Productivity/Databases/Servers
PreReq: %insserv_prereq %fillup_prereq
@@ -110,7 +111,7 @@
Provides: postgresql-server = %pg_minor_version
%package docs
-License: BSD 3-Clause
+License: BSD 3-clause (or similar)
Summary: HTML Documentation for PostgreSQL
Group: Productivity/Databases/Tools
@@ -136,7 +137,7 @@
Jan Wieck
%package contrib
-License: BSD 3-Clause
+License: BSD 3-clause (or similar)
Summary: Contributed Extensions and Additions to PostgreSQL
Group: Productivity/Databases/Tools
Requires: postgresql-server = %pg_minor_version
@@ -185,7 +186,7 @@
Jan Wieck
%package devel
-License: BSD 3-Clause
+License: BSD 3-clause (or similar)
Summary: PostgreSQL development header files and libraries
Group: Productivity/Databases/Tools
Requires: postgresql-libs = %pg_minor_version
@@ -216,6 +217,10 @@
%setup -q
%patch1
%patch2
+# apply the following patch only on SLE10
+%if %suse_version == 1010
+%patch3 -p1
+%endif
%build
export CFLAGS="%optflags $SP"
@@ -228,7 +233,7 @@
--includedir=%_includedir/pgsql \
--datadir=%_datadir/postgresql \
--mandir=%_mandir \
- --with-docdir=%_docdir \
+ --docdir=%_docdir \
--disable-rpath \
--enable-nls \
--enable-thread-safety \
@@ -294,7 +299,7 @@
%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/FAQ* 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
@@ -354,9 +359,9 @@
%dir %_docdir/postgresql
%_docdir/postgresql/[[:upper:]]*
%_docdir/postgresql/bug.template
-%_datadir/locale/*/*/pg_dump.mo
-%_datadir/locale/*/*/pgscripts.mo
-%_datadir/locale/*/*/psql.mo
+%_datadir/locale/*/*/pg_dump-*.mo
+%_datadir/locale/*/*/pgscripts-*.mo
+%_datadir/locale/*/*/psql-*.mo
# command line tools
%_bindir/createdb
%doc %_mandir/man1/createdb.1*
@@ -403,7 +408,8 @@
%files libs
%defattr(-,root,root)
%_libdir/lib*.so.*
-%_datadir/locale/*/*/libpq.mo
+%_datadir/locale/*/*/libpq*.mo
+%_datadir/locale/*/*/ecpglib*-*.mo
%files server
%defattr(-,root,root)
@@ -420,8 +426,6 @@
%_datadir/postgresql/tsearch_data
%_bindir/initdb
%doc %_mandir/man1/initdb.1*
-%_bindir/ipcclean
-%doc %_mandir/man1/ipcclean.1*
%_bindir/pg_ctl
%doc %_mandir/man1/pg_ctl.1*
%_bindir/pg_controldata
@@ -435,11 +439,12 @@
%dir %_datadir/postgresql
%_datadir/postgresql/timezone*
%_datadir/postgresql/*.*
-%_datadir/locale/*/*/initdb.mo
-%_datadir/locale/*/*/postgres.mo
-%_datadir/locale/*/*/pg_controldata.mo
-%_datadir/locale/*/*/pg_ctl.mo
-%_datadir/locale/*/*/pg_resetxlog.mo
+%_datadir/locale/*/*/initdb-*.mo
+%_datadir/locale/*/*/postgres-*.mo
+%_datadir/locale/*/*/pg_controldata-*.mo
+%_datadir/locale/*/*/pg_ctl-*.mo
+%_datadir/locale/*/*/pg_resetxlog-*.mo
+%_datadir/locale/*/*/plpgsql-*.mo
%_libdir/postgresql/*_and_*.so
%attr(750,postgres,postgres) %dir /var/lib/pgsql
%attr(700,postgres,postgres) %dir /var/lib/pgsql/data
@@ -454,7 +459,8 @@
%_libdir/lib*.so
%_libdir/libpgport.a
%_libdir/postgresql/pgxs
-%_datadir/locale/*/*/pg_config.mo
+%_datadir/locale/*/*/pg_config-*.mo
+%_datadir/locale/*/*/ecpg-*.mo
%doc %_mandir/man1/ecpg.1*
%doc %_mandir/man1/pg_config.1*
++++++ postgresql-8.4.0-sle10-timestamptz.patch ++++++
Only for SLE10. On other platforms, the test works.
poeml, Mon Jul 27 19:12:40 CEST 2009
diff -uNr postgresql-8.4.0.orig/src/test/regress/expected/timestamptz.out postgresql-8.4.0/src/test/regress/expected/timestamptz.out
--- postgresql-8.4.0.orig/src/test/regress/expected/timestamptz.out 2009-03-22 02:12:32.000000000 +0100
+++ postgresql-8.4.0/src/test/regress/expected/timestamptz.out 2009-07-27 19:11:39.280087000 +0200
@@ -153,7 +153,7 @@
SELECT '20500710 173201 Europe/Helsinki'::timestamptz; -- DST
timestamptz
------------------------------
- Sun Jul 10 07:32:01 2050 PDT
+ Sun Jul 10 07:32:01 2050 PST
(1 row)
SELECT '20500110 173201 Europe/Helsinki'::timestamptz; -- non-DST
@@ -165,7 +165,7 @@
SELECT '205000-07-10 17:32:01 Europe/Helsinki'::timestamptz; -- DST
timestamptz
--------------------------------
- Thu Jul 10 07:32:01 205000 PDT
+ Thu Jul 10 07:32:01 205000 PST
(1 row)
SELECT '205000-01-10 17:32:01 Europe/Helsinki'::timestamptz; -- non-DST
++++++ postgresql-8.3.7.tar.bz2 -> postgresql-8.4.0.tar.bz2 ++++++
postgresql/postgresql-8.3.7.tar.bz2 /mounts/work_src_done/STABLE/postgresql/postgresql-8.4.0.tar.bz2 differ: char 11, line 1
++++++ postgresql-README.SuSE.de ++++++
--- /var/tmp/diff_new_pack.nMwP2a/_old 2009-07-29 17:15:41.000000000 +0200
+++ /var/tmp/diff_new_pack.nMwP2a/_new 2009-07-29 17:15:41.000000000 +0200
@@ -16,6 +16,8 @@
angehalten werden (als root: "rcpostgresql stop"). Eventuell müssen
zusätzlich noch einige Konfigurationsdateien aus /var/lib/pgsql/data
gesichert werden, z.B. pg_hba.conf und postgresql.conf .
+Achtung: seit Version 8.4 muss in pg_hba.conf "ident sameuser" durch
+"ident" ersetzt werden.
Danach können Sie die bisherigen Datenbankdateien löschen
++++++ postgresql-README.SuSE.en ++++++
--- /var/tmp/diff_new_pack.nMwP2a/_old 2009-07-29 17:15:41.000000000 +0200
+++ /var/tmp/diff_new_pack.nMwP2a/_new 2009-07-29 17:15:41.000000000 +0200
@@ -15,6 +15,8 @@
"rcpostgresql stop"). Further configuration files in
/var/lib/pgsql/data, including pg_hba.conf and postgresql.conf,
may need to be backed up as well.
+Note: since version 8.4, "ident sameuser" needs to be replaced with
+"ident" in pg_hba.conf.
Afterwards, delete the previous database files
++++++ postgresql-init ++++++
--- /var/tmp/diff_new_pack.nMwP2a/_old 2009-07-29 17:15:41.000000000 +0200
+++ /var/tmp/diff_new_pack.nMwP2a/_new 2009-07-29 17:15:41.000000000 +0200
@@ -112,7 +112,7 @@
LANG=${POSTGRES_LANG:-$RC_LANG}
INITDB=/usr/bin/initdb
install -d -o postgres -g postgres -m 700 ${DATADIR} && su - postgres -c \
- "$INITDB --locale=$LANG --auth=\"ident sameuser\" $DATADIR &> initlog" ||
+ "$INITDB --locale=$LANG --auth=\"ident\" $DATADIR &> initlog" ||
rc_failed
rc_status -v
rc_status || {
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Remember to have fun...
--
To unsubscribe, e-mail: opensuse-commit+unsubscribe@opensuse.org
For additional commands, e-mail: opensuse-commit+help@opensuse.org