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

Download PostgreSQL 9.6.3

PostgreSQL for Mac

 -  100% Safe  -  Freeware

What's new in this version:

Changes:
- Restrict visibility of pg_user_mappings.umoptions, to protect passwords stored as user mapping options (Michael Paquier, Feike Steenbergen)
- Prevent exposure of statistical information via leaky operators (Peter Eisentraut)
- Restore libpq's recognition of the PGREQUIRESSL environment variable (Daniel Gustafsson)
- Fix possibly-invalid initial snapshot during logical decoding (Petr Jelinek, Andres Freund)
- Fix possible corruption of "init forks" of unlogged indexes (Robert Haas, Michael Paquier)
- Fix incorrect reconstruction of pg_subtrans entries when a standby server replays a prepared but uncommitted two-phase transaction (Tom Lane)
- Avoid possible crash in walsender due to failure to initialize a string buffer (Stas Kelvich, Fujii Masao)
- Fix possible crash when rescanning a nearest-neighbor index-only scan on a GiST index (Tom Lane)
- Prevent delays in postmaster's launching of multiple parallel worker processes (Tom Lane)
- Fix postmaster's handling of fork() failure for a background worker process (Tom Lane)
- Fix possible "no relation entry for relid 0" error when planning nested set operations (Tom Lane)
- Fix assorted minor issues in planning of parallel queries (Robert Haas)
- Avoid applying "physical targetlist" optimization to custom scans (Dmitry Ivanov, Tom Lane)
- Use the correct sub-expression when applying a FOR ALL row-level-security policy (Stephen Frost)
- Ensure parsing of queries in extension scripts sees the results of immediately-preceding DDL (Julien Rouhaud, Tom Lane)
- Skip tablespace privilege checks when ALTER TABLE ... ALTER COLUMN TYPE rebuilds an existing index (Noah Misch)
- Fix ALTER TABLE ... VALIDATE CONSTRAINT to not recurse to child tables when the constraint is marked NO INHERIT (Amit Langote)
- Avoid dangling pointer in COPY ... TO when row-level security is active for the source table (Tom Lane)
- Avoid accessing an already-closed relcache entry in CLUSTER and VACUUM FULL (Tom Lane)
- Fix VACUUM to account properly for pages that could not be scanned due to conflicting page pins (Andrew Gierth)
- Ensure that bulk-tuple-transfer loops within a hash join are interruptible by query cancel requests (Tom Lane, Thomas Munro)
- Fix incorrect support for certain box operators in SP-GiST (Nikita Glukhov)
- Fix integer-overflow problems in interval comparison (Kyotaro Horiguchi, Tom Lane)
- Fix cursor_to_xml() to produce valid output with tableforest = false (Thomas Munro, Peter Eisentraut)
- Fix roundoff problems in float8_timestamptz() and make_interval() (Tom Lane)
- Fix pg_get_object_address() to handle members of operator families correctly (Álvaro Herrera)
- Fix cancelling of pg_stop_backup() when attempting to stop a non-exclusive backup (Michael Paquier, David Steele)
- Improve performance of pg_timezone_names view (Tom Lane, David Rowley)
- Reduce memory management overhead for contexts containing many large blocks (Tom Lane)
- Fix sloppy handling of corner-case errors from lseek() and close() (Tom Lane)
- Fix incorrect check for whether postmaster is running as a Windows service (Michael Paquier)
- Fix ecpg to support COMMIT PREPARED and ROLLBACK PREPARED (Masahiko Sawada)
- Fix a double-free error when processing dollar-quoted string literals in ecpg (Michael Meskes)
- Fix pgbench to handle the combination of --connect and --rate options correctly (Fabien Coelho)
- Fix pgbench to honor the long-form option spelling --builtin, as per its documentation (Tom Lane)
- Fix pg_dump/pg_restore to correctly handle privileges for the public schema when using --clean option (Stephen Frost)
- In pg_dump, fix incorrect schema and owner marking for comments and security labels of some types of database objects (Giuseppe Broccolo, Tom Lane)
- Fix typo in pg_dump's query for initial privileges of a procedural language (Peter Eisentraut)
- Avoid emitting an invalid list file in pg_restore -l when SQL object names contain newlines (Tom Lane)
- Fix pg_upgrade to transfer comments and security labels attached to "large objects" (blobs) (Stephen Frost)
- Improve error handling in contrib/adminpack's pg_file_write() function (Noah Misch)
- In contrib/dblink, avoid leaking the previous unnamed connection when establishing a new unnamed connection (Joe Conway)
- Fix contrib/pg_trgm's extraction of trigrams from regular expressions (Tom Lane)
- In contrib/postgres_fdw, allow join conditions that contain shippable extension-provided functions to be pushed to the remote server (David Rowley, Ashutosh Bapat)
- Support Tcl 8.6 in MSVC builds (Álvaro Herrera)
- Sync our copy of the timezone library with IANA release tzcode2017b (Tom Lane)
- Update time zone data files to tzdata release 2017b for DST law changes in Chile, Haiti, and Mongolia, plus historical corrections for Ecuador, Kazakhstan, Liberia, and Spain. Switch to numeric abbreviations for numerous time zones in South America, the Pacific and Indian oceans, and some Asian and Middle Eastern countries.
- Use correct daylight-savings rules for POSIX-style time zone names in MSVC builds (David Rowley)



Join our mailing list

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