Hello community, here is the log from the commit of package postgresql for openSUSE:Factory checked in at Fri May 15 22:05:58 CEST 2009. -------- --- postgresql/postgresql.changes 2009-01-07 13:26:58.000000000 +0100 +++ postgresql/postgresql.changes 2009-05-06 17:59:50.000000000 +0200 @@ -1,0 +2,28 @@ +Wed May 6 17:57:43 CEST 2009 - max@suse.de + +- Remove dependency on local posixrules from horology test. + +------------------------------------------------------------------- +Mon Mar 23 18:12:42 CET 2009 - max@suse.de + +- Security release 8.3.7 + + * Fixes a vulnerability that allowed remote authenticated + users to cause a denial of service (stack consumption) + via mismatched encoding conversion requests. + + * Details of the other bugfixes contained in this and + previous releases can be found here: + http://www.postgresql.org/docs/8.3/static/release.html + /usr/share/doc/packages/postgresql/HISTORY + +- Users of GiST indexes should "REINDEX" them after installing + this update. + +- Re-added libpgport.a to the devel package, as some apps require + it, although it is meant to be internal to the PostgreSQL + backend. + +- Fix removal of leftover files on database startup (bnc#473644). + +------------------------------------------------------------------- calling whatdependson for head-i586 Old: ---- postgresql-8.3.5.tar.bz2 New: ---- postgresql-8.3.7.tar.bz2 postgresql-regress.patch ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ postgresql-pl.spec ++++++ --- /var/tmp/diff_new_pack.n16484/_old 2009-05-15 22:01:41.000000000 +0200 +++ /var/tmp/diff_new_pack.n16484/_new 2009-05-15 22:01:41.000000000 +0200 @@ -1,5 +1,5 @@ # -# spec file for package postgresql-pl (Version 8.3.5) +# spec file for package postgresql-pl (Version 8.3.7) # # Copyright (c) 2009 SUSE LINUX Products GmbH, Nuernberg, Germany. # @@ -23,8 +23,8 @@ BuildRequires: ncurses-devel BuildRequires: python-devel tcl-devel Summary: The PL/Tcl, PL/Perl, and PL/Python Procedural Languages for PostgreSQL -Version: 8.3.5 -Release: 2 +Version: 8.3.7 +Release: 1 %define pg_minor_version %(echo %version | cut -f1-2 -d.) License: BSD 3-Clause Group: Productivity/Databases/Servers ++++++ postgresql.spec ++++++ --- /var/tmp/diff_new_pack.n16484/_old 2009-05-15 22:01:41.000000000 +0200 +++ /var/tmp/diff_new_pack.n16484/_new 2009-05-15 22:01:41.000000000 +0200 @@ -1,5 +1,5 @@ # -# spec file for package postgresql (Version 8.3.5) +# spec file for package postgresql (Version 8.3.7) # # Copyright (c) 2009 SUSE LINUX Products GmbH, Nuernberg, Germany. # @@ -22,8 +22,8 @@ BuildRequires: openldap2-devel openssl-devel pam-devel readline-devel zlib-devel BuildRequires: ncurses-devel Summary: Basic Clients and Utilities for PostgreSQL -Version: 8.3.5 -Release: 2 +Version: 8.3.7 +Release: 1 %define pg_minor_version %(echo %version | cut -f1-2 -d.) License: BSD 3-Clause Group: Productivity/Databases/Tools @@ -37,6 +37,7 @@ Source17: postgresql-rpmlintrc Source99: postgresql-pl.spec Patch1: postgresql-8.3-conf.patch +Patch2: postgresql-regress.patch PreReq: postgresql-libs = %pg_minor_version Url: http://www.postgresql.org/ Provides: postgresql = %pg_minor_version @@ -214,6 +215,7 @@ %prep %setup -q %patch1 +%patch2 %build export CFLAGS="%optflags $SP" @@ -264,8 +266,8 @@ %install make DESTDIR=%buildroot install -# Don't ship static libraries. -rm %buildroot/%_libdir/*.a +# Don't ship static libraries, libpgport.a is needed, though. +rm %buildroot/%_libdir/{libecpg,libecpg_compat,libpgtypes,libpq}.a # # Install and collect the contrib stuff # @@ -450,12 +452,30 @@ %_bindir/ecpg %_bindir/pg_config %_libdir/lib*.so +%_libdir/libpgport.a %_libdir/postgresql/pgxs %_datadir/locale/*/*/pg_config.mo %doc %_mandir/man1/ecpg.1* %doc %_mandir/man1/pg_config.1* %changelog +* Wed May 06 2009 max@suse.de +- Remove dependency on local posixrules from horology test. +* Mon Mar 23 2009 max@suse.de +- Security release 8.3.7 + * Fixes a vulnerability that allowed remote authenticated + users to cause a denial of service (stack consumption) + via mismatched encoding conversion requests. + * Details of the other bugfixes contained in this and + previous releases can be found here: + http://www.postgresql.org/docs/8.3/static/release.html + /usr/share/doc/packages/postgresql/HISTORY +- Users of GiST indexes should "REINDEX" them after installing + this update. +- Re-added libpgport.a to the devel package, as some apps require + it, although it is meant to be internal to the PostgreSQL + backend. +- Fix removal of leftover files on database startup (bnc#473644). * Wed Jan 07 2009 olh@suse.de - obsolete old -XXbit packages (bnc#437293) * Wed Nov 05 2008 max@suse.de @@ -782,7 +802,7 @@ - Correct PreReq * Mon Aug 19 2002 kukuk@suse.de - Fix requires egenix-mx-base -> python-egenix-mx-base -* Thu Aug 15 2002 ro@suse.de +* Fri Aug 16 2002 ro@suse.de - don't chmod 644 to directories * Wed Aug 14 2002 ro@suse.de - added "missingok" to logrotate config @@ -958,7 +978,7 @@ - changed postgresql-python to use Python2.0 instead of 1.5 * Sat Oct 28 2000 kukuk@suse.de - Add python-devel to need for build -* Mon Oct 23 2000 bk@suse.de +* Tue Oct 24 2000 bk@suse.de - integrated change from max: - changed /sbin/init.d/postgres and SuSEconfig.postgres to work arround YaST that quotes the value of POSTGRES_DATADIR ++++++ postgresql-8.3.5.tar.bz2 -> postgresql-8.3.7.tar.bz2 ++++++ postgresql/postgresql-8.3.5.tar.bz2 postgresql/postgresql-8.3.7.tar.bz2 differ: byte 11, line 1 ++++++ postgresql-init ++++++ --- /var/tmp/diff_new_pack.n16484/_old 2009-05-15 22:01:41.000000000 +0200 +++ /var/tmp/diff_new_pack.n16484/_new 2009-05-15 22:01:41.000000000 +0200 @@ -123,7 +123,7 @@ echo -n "Starting PostgreSQL" ## remove old socket, if it exists and no daemon is running. checkproc -p $PIDFILE $H || { - rm -f /tmp/.s.PGSQL.5432 $PIDFILE + rm -f /tmp/.s.PGSQL.* $PIDFILE } ## Start daemon with startproc(8). If this fails ++++++ postgresql-regress.patch ++++++ --- src/test/regress/expected/horology.out +++ src/test/regress/expected/horology.out @@ -601,26 +601,26 @@ (1 row) -- timestamp with time zone, interval arithmetic around DST change -SET TIME ZONE 'CST7CDT'; -SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as "Apr 3, 12:00"; +SET TIME ZONE 'CST6CDT'; +SELECT timestamp with time zone '2005-04-02 12:00-06' + interval '1 day' as "Apr 3, 12:00"; Apr 3, 12:00 ------------------------------ Sun Apr 03 12:00:00 2005 CDT (1 row) -SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00"; +SELECT timestamp with time zone '2005-04-02 12:00-06' + interval '24 hours' as "Apr 3, 13:00"; Apr 3, 13:00 ------------------------------ Sun Apr 03 13:00:00 2005 CDT (1 row) -SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00"; +SELECT timestamp with time zone '2005-04-03 12:00-05' - interval '1 day' as "Apr 2, 12:00"; Apr 2, 12:00 ------------------------------ Sat Apr 02 12:00:00 2005 CST (1 row) -SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as "Apr 2, 11:00"; +SELECT timestamp with time zone '2005-04-03 12:00-05' - interval '24 hours' as "Apr 2, 11:00"; Apr 2, 11:00 ------------------------------ Sat Apr 02 11:00:00 2005 CST --- src/test/regress/pg_regress.c +++ src/test/regress/pg_regress.c @@ -63,7 +63,7 @@ /* currently we can use the same diff switches on all platforms */ const char *basic_diff_opts = "-w"; -const char *pretty_diff_opts = "-w -C3"; +const char *pretty_diff_opts = "-w -U5"; /* options settable from command line */ _stringlist *dblist = NULL; --- src/test/regress/sql/horology.sql +++ src/test/regress/sql/horology.sql @@ -113,11 +113,11 @@ SELECT (timestamp with time zone 'tomorrow' > 'now') as "True"; -- timestamp with time zone, interval arithmetic around DST change -SET TIME ZONE 'CST7CDT'; -SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as "Apr 3, 12:00"; -SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00"; -SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00"; -SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as "Apr 2, 11:00"; +SET TIME ZONE 'CST6CDT'; +SELECT timestamp with time zone '2005-04-02 12:00-06' + interval '1 day' as "Apr 3, 12:00"; +SELECT timestamp with time zone '2005-04-02 12:00-06' + interval '24 hours' as "Apr 3, 13:00"; +SELECT timestamp with time zone '2005-04-03 12:00-05' - interval '1 day' as "Apr 2, 12:00"; +SELECT timestamp with time zone '2005-04-03 12:00-05' - interval '24 hours' as "Apr 2, 11:00"; RESET TIME ZONE; ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Remember to have fun... -- To unsubscribe, e-mail: opensuse-commit+unsubscribe@opensuse.org For additional commands, e-mail: opensuse-commit+help@opensuse.org