A powerful, open source relational database system

PostgreSQL for Mac

Join our mailing list

Stay up to date with latest software releases, news, software discounts, deals and more.

Subscribe
Download PostgreSQL 10.2

  -  138 MB  -  Freeware

What's new in this version:

Security Issues:
- CVE-2018-1052: Fix the processing of partition keys containing multiple expressions
- CVE-2018-1053: Ensure that all temporary files made with "pg_upgrade" are non-world-readable

Bug Fixes and Improvements:
- Fix crash and potential disclosure of backend memory when processing partition keys containing multiple expressions
- Fix potential disclosure of temporary files containing database passwords created by pg_upgrade by not allowing these files to be world-accessible
- Fix cases where VACUUM would not remove dead rows if they were updated while "key-share" locked, leading to potential data corruption
- Fix for GIN indexes to prevent bloat by ensuring the pending-insertions list is cleaned up by VACUUM
- Fix potential index corruption with hash indexes due to failure to mark metapages as dirty
- Fix several potential crash scenarios for parallel queries, including when a bitmap heap scan cannot allocate memory
- Fix several potential hang-ups in parallel queries, including when a parallel worker fails to start
- Fix collection of EXPLAIN statistics from parallel workers
- Prevent fake deadlock failures when multiple sessions are running CREATE INDEX CONCURRENTLY
- Fix for trigger behavior when using logical replication
- Several fixes for "walsender" functionality to improve stability as well as visibility into the replication process
- Fix logical decoding to correctly clean up disk files for crashed transactions
- Several fixes for identity columns, including disallowing identity columns on tables derived from composite types and partitions
- Fix handling of list partitioning constraints for partition keys of boolean and array types
- Fix incorrectly generated plans for UPDATE and DELETE queries when a table has a mix of inherited regular and foreign child tables
- Fix incorrect query results from cases involving GROUPING SETS when used with flattened subqueries
- Fix UNION/INTERSECT/EXCEPT over zero columns, e.g. "SELECT UNION SELECT;"
- Several fixes for subqueries within a LATERAL subquery
- Several improvements for query planning estimation
- Allow a client that supports SCRAM channel binding, such as a future version of PostgreSQL or libpq, to connect to a PostgreSQL 10 server
- Fix sample INSTR() functions used to help transition from Oracle(r) PL/SQL to PostgreSQL PL/pgSQL to correctly match Oracle functional behavior
- Fix pg_dump to make permissions (ACL), security label, and comment entries reliably identifiable in archive outputs
- Modify behavior for contrib/cube's "cube ~> int" operator to make it compatible with KNN search. This is a backwards incompatible change and any expression indexes or materialized views using this operator will need to be reindexed and refreshed, respectively.
- Several fixes in contrib/postgres_fdw to prevent query planner errors
- Added modern examples of auto-start scripts for PostgreSQL on macOS in the contrib/start-scripts/macos directory
- Several fixes for Windows, including postmaster startup and compatibility with libperl
- Spinlock fixes and support for Motorola 68K and 88K architectures
- This update also contains tzdata release 2018c, with updates for DST law changes in Brazil, Sao Tome and Principe, plus historical corrections for Bolivia, Japan, and South Sudan. The US/Pacific-New zone has been removed (it was only an alias for "America/Los_Angeles" anyway)

Join our mailing list

Stay up to date with latest software releases, news, software discounts, deals and more.

Subscribe