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.
-
Submitted by
Reinhard Max (rmax)