PostgreSQL 9.4.2

Title:

PostgreSQL 9.4.2

File Size:

55.9 MB

Requirements:

Windows (All Versions)

Language:

en-us

License:

Freeware

Date Added:

25 May 2015

Publisher:

PostgreSQL Global Development Group

Homepage:

http://www.postgresql.org

MD5 Checksum:

9C7BC458A57D36D2F885934909EFE00D

- Avoid possible crash when client disconnects just before the authentication timeout expires
- Improve detection of system-call failures
- In contrib/pgcrypto, uniformly report decryption failures as "Wrong key or corrupt data"
- Protect against wraparound of multixact member IDs
- Fix incorrect declaration of contrib/citext's regexp_matches() functions
- Render infinite dates and timestamps as infinity when converting to json, rather than throwing an error
- Fix json/jsonb's populate_record() and to_record() functions to handle empty input properly
- Fix incorrect checking of deferred exclusion constraints after a HOT update
- Fix behavior when changing foreign key constraint deferrability status with ALTER TABLE ... ALTER CONSTRAINT
- Fix planning of star-schema-style queries
- Prevent improper reordering of antijoins (NOT EXISTS joins) versus other outer joins
- Fix incorrect matching of subexpressions in outer-join plan nodes
- Fix GEQO planner to cope with failure of its join order heuristic
- Ensure that row locking occurs properly when the target of an UPDATE or DELETE is a security-barrier view
- Fix possible deadlock at startup when max_prepared_transactions is too small
- Don't archive useless preallocated WAL files after a timeline switch
- Recursively fsync() the data directory after a crash
- Fix autovacuum launcher's possible failure to shut down, if an error occurs after it receives SIGTERM
- Fix failure to handle invalidation messages for system catalogs early in session startup
- Fix crash in BackendIdGetTransactionIds() when trying to get status for a backend process that just exited
- Fix crash when doing COPY IN to a table with check constraints that contain whole-row references
- Avoid waiting for WAL flush or synchronous replication during commit of a transaction that was read-only so far as the user is concerned
- Avoid busy-waiting with short recovery_min_apply_delay values
- Fix crash when manipulating hash indexes on temporary tables
- Fix possible failure during hash index bucket split, if other processes are modifying the index concurrently
- Fix memory leaks in GIN index vacuum
- Check for interrupts while analyzing index expressions
- Ensure tableoid of a foreign table is reported correctly when a READ COMMITTED recheck occurs after locking rows in SELECT FOR UPDATE, UPDATE, or DELETE
- Add the name of the target server to object description strings for foreign-server user mappings
- Include the schema name in object identity strings for conversions
- Recommend setting include_realm to 1 when using Kerberos/GSSAPI/SSPI authentication
- Remove code for matching IPv4 pg_hba.conf entries to IPv4-in-IPv6 addresses
- Fix status reporting for terminated background workers that were never actually started
- After a database crash, don't restart background workers that are marked BGW_NEVER_RESTART
- Report WAL flush, not insert, position in IDENTIFY_SYSTEM replication command
- While shutting down service on Windows, periodically send status updates to the Service Control Manager to prevent it from killing the service too soon; and ensure that pg_ctl will wait for shutdown
- Reduce risk of network deadlock when using libpq's non-blocking mode
- In libpq, fix misparsing of empty values in URI connection strings
- Fix array handling in ecpg
- Fix psql to sanely handle URIs and conninfo strings as the first parameter to \connect
- Suppress incorrect complaints from psql on some platforms that it failed to write ~/.psql_history at exit
- Fix pg_dump's rule for deciding which casts are system-provided casts that should not be dumped
- In pg_dump, fix failure to honor -Z compression level option together with -Fd
- Make pg_dump consider foreign key relationships between extension configuration tables while choosing dump order
- Avoid possible pg_dump failure when concurrent sessions are creating and dropping temporary functions
- Fix dumping of views that are just VALUES(...) but have column aliases
- Ensure that a view's replication identity is correctly set to nothing during dump/restore
- In pg_upgrade, force timeline 1 in the new cluster
- In pg_upgrade, check for improperly non-connectable databases before proceeding
- In pg_upgrade, quote directory paths properly in the generated delete_old_cluster script
- In pg_upgrade, preserve database-level freezing info properly
- Run pg_upgrade and pg_resetxlog with restricted privileges on Windows, so that they don't fail when run by an administrator
- Improve handling of readdir() failures when scanning directories in initdb and pg_basebackup
- Fix slow sorting algorithm in contrib/intarray
- Fix compile failure on Sparc V8 machines
- Silence some build warnings on OS X
- Update time zone data files to tzdata release 2015d for DST law changes in Egypt, Mongolia, and Palestine, plus historical changes in Canada and Chile. Also adopt revised zone abbreviations for the America/Adak zone (HST/HDT not HAST/HADT).