openSUSE Recommended Update: Recommended update for postgresql10 ______________________________________________________________________________ Announcement ID: openSUSE-RU-2021:1351-1 Rating: moderate References: #1179945 #1185952 #1187751 #1190177 Affected Products: openSUSE Leap 15.2 ______________________________________________________________________________ An update that has four recommended fixes can now be installed. Description: This update for postgresql10 fixes the following issues: - Upgrade to version 10.18. (bsc#1190177) - A dump/restore is not required for those running 10.X. - if you are upgrading from a version older than 10.16 a reindexing of indexes after the upgrade may be advisable. - Allow PostgreSQL version 10 to build with ICU 69 and newer - Clarify error messages referring to 'non-negative' values - Fix incorrect log message when 'point-in-time' recovery stops at a 'ROLLBACK PREPARED' record - In 'contrib/postgres_fdw', avoid attempting catalog lookups after an error - Messages about data conversion errors will now mention the query's table and column aliases (if used) rather than the true underlying name of a foreign table or column. - Avoid problems when 'switching pg_receivewal' between compressed and non-compressed 'WAL' storage - Extend 'pg_upgrade' to detect and warn about extensions that should be upgraded. - Make 'pg_upgrade' carry forward the old installation's 'oldestXID' value. - This solves unwanted forced shutdowns happening soon after an upgrade in particular on installations using large values of 'autovacuum_freeze_max_age'. - Avoid 'invalid creation date in header' warnings observed when running 'pg_restore' on an archive file created in a different time zone. - In psql and other client programs, avoid overrunning the ends of strings when dealing with invalidly-encoded data. - Don't abort the process for an out-of-memory failure in libpq's printing functions - Fix uninitialized-variable bug that could cause 'PL/pgSQL' to act as though an 'INTO' clause specified 'STRICT', even though it didn't. - Fix latent crash in sorting code - Fix possible race condition when releasing BackgroundWorkerSlots - Solve a build issue fix build with 'llvm12' on s390x. (bsc#1185952) - Re-enable 'icu' for 'PostgreSQL 10'. (bsc#1179945) - Relax the dependency of 'postgresqlXX-server-devel' on 'llvm' and 'clang'. (bsc#1187751) This update was imported from the SUSE:SLE-15-SP1:Update update project. Patch Instructions: To install this openSUSE Recommended Update use the SUSE recommended installation methods like YaST online_update or "zypper patch". Alternatively you can run the command listed for your product: - openSUSE Leap 15.2: zypper in -t patch openSUSE-2021-1351=1 Package List: - openSUSE Leap 15.2 (i586 x86_64): postgresql10-10.18-lp152.2.24.1 postgresql10-contrib-10.18-lp152.2.24.1 postgresql10-contrib-debuginfo-10.18-lp152.2.24.1 postgresql10-debuginfo-10.18-lp152.2.24.1 postgresql10-debugsource-10.18-lp152.2.24.1 postgresql10-devel-10.18-lp152.2.24.1 postgresql10-devel-debuginfo-10.18-lp152.2.24.1 postgresql10-plperl-10.18-lp152.2.24.1 postgresql10-plperl-debuginfo-10.18-lp152.2.24.1 postgresql10-plpython-10.18-lp152.2.24.1 postgresql10-plpython-debuginfo-10.18-lp152.2.24.1 postgresql10-pltcl-10.18-lp152.2.24.1 postgresql10-pltcl-debuginfo-10.18-lp152.2.24.1 postgresql10-server-10.18-lp152.2.24.1 postgresql10-server-debuginfo-10.18-lp152.2.24.1 postgresql10-test-10.18-lp152.2.24.1 - openSUSE Leap 15.2 (noarch): postgresql10-docs-10.18-lp152.2.24.1 References: https://bugzilla.suse.com/1179945 https://bugzilla.suse.com/1185952 https://bugzilla.suse.com/1187751 https://bugzilla.suse.com/1190177