2016-05-12 Cumulative Bug Fix Release

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.3, 9.4.8, 9.3.13, 9.2.17 and 9.1.22. This release fixes a number of issues reported by users over the last two months. Most database administrators should plan to upgrade at the next available downtime, unless they have been affected directly by the fixed issues.

Bug Fixes and Improvements

This update fixes several problems which caused downtime for users, including:

• Clearing the OpenSSL error queue before OpenSSL calls, preventing errors in SSL connections, particularly when using the Python, Ruby or PHP OpenSSL wrappers
• Fixed the "failed to build N-way joins" planner error
• Fixed incorrect handling of equivalence in multilevel nestloop query plans, which could emit rows which didn't match the WHERE clause.
• Prevented two memory leaks with using GIN indexes, including a potential index corruption risk.

The release also includes many other bug fixes for reported issues, many of which affect all supported versions:

• Fix corner-case parser failures occurring when operator_precedence_warning is turned on
• Prevent possible misbehavior of TH, th, and Y,YYY format codes in to_timestamp()
• Correct dumping of VIEWs and RULEs which use ANY (array) in a subselect
• Disallow newlines in ALTER SYSTEM parameter values
• Avoid possible misbehavior after failing to remove a tablespace symlink
• Fix crash in logical decoding on alignment-picky platforms
• Avoid repeated requests for feedback from receiver while shutting down walsender
• Multiple fixes for pg_upgrade
• Support building with Visual Studio 2015

This update also contains tzdata release 2016d, with updates for Russia, Venezuela, Kirov, and Tomsk.

Updating

All PostgreSQL update releases are cumulative. As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users who have skipped one or more update releases may need to run additional, post-update steps; please see the release notes for earlier versions for details.

Links:

• Download
• Release Notes
• Security Page
• Abbreviated Keys Issue

La “digital disruption” riguarda tutti e molte organizzazioni si stanno …

Read More

Beitrag von Jörg Knippschild,Head of PreSales Germany

Mehr als sieben Milliarden …

Read More

VMware’s vRealize Suite delivers the industry’s most complete solution for building and managing multi-vendor private, public or hybrid cloud environments See proven results from our customers and learn how you can do more with your data center too from our vRealize Suite Infographic. Key Benefits Agility – speeds up the IT Services delivery allowing IT […]

The post vRealize Suite Customer Results appeared first on VMware Cloud Management.

Nobody wants to provision physical machines anymore. It’s a time-consuming, costly exercise fraught with user downtime. But what do you do when you can’t give virtual desktops (VDI) to contractors, offshore developers or field workers? That’s where VMware Horizon FLEX comes in. FLEX is the secure policy management infrastructure that gives you total control over […]

The post [Webinar] Understanding the Benefits of Offline VDI: Introducing Horizon FLEX appeared first on VMware End-User Computing Blog.

Recently, we introduced you to EZ Link, our new Socialcast login feature. Right from your Socialcast web or mobile app, you just click a button to send yourself an email with a link that logs you into the Socialcast mobile app.

Read more on Developing a Mobile App for People with Too Many Passwords…

VMware Education Services continually releases new courses designed to grow your skills so you can exploit the opportunities provided by VMware technologies. New this month: VMware NSX: Troubleshooting and Operations [V6.2] This course teaches you to troubleshoot and operate a VMware NSX® deployment by isolating problems and identifying resolutions through a systematic process. VMware NSX: […]

The post New Courses covering NSX, Horizon 7 and more appeared first on VMware Education and Certification Blog.

U.S. Auto Sales needed to update its IT infrastructure after an unprecedented ice storm slammed the Southeastern United States, knocking its payment collection system offline. The company, specializing in preowned high-end vehicles for customers without access to traditional financing, could not collect payment from many of its 20,000 accounts. Customers would have to either call […]

The post VMware and Cirrity Help U.S. Auto Sales to Speed Past Sales Records with Virtual Desktops appeared first on VMware vCloud Air Blog.

We’re almost half way through the year, and it is shapingup to be a “tipping-point” year forhyper-convergence and HCI. Combine faster CPUs, lower cost flash (with exciting technologies on the horizon) and software innovation with the majority of data centers standardizing on server virtualization, now is the time to extend existing infrastructure investments with newer,

The post Understanding the Layers of Hyper-Converged Infrastructure appeared first on Virtual Blocks.

By Ton van Tubergen In my role as an Operations Transformation Architect, I have been involved in many large and small IT Transformations, addressing people, process, technology, governance and organizational aspects and their dependencies. As a responsible IT leader, managing uncertainty and risks will be an important part of steering the organization through a transformation. […]

The post It’s all in the Context: Practical Advice for Using IT Benchmarking appeared first on VMware Operations Transformation Services.

This blog originally appeared on the vSphere Blog and was authored by Don Sullivan VMware Validated Design for an All-Flash Virtual SAN with NSX Running High Workload Oracle – A VMware, Intel and Quanta Project from Principled Technologies The rigorous process of following a VMware Validated Design (V2D) to build a Business Critical Applications (BCA)

The post VMware Validated Design with Virtual SAN and NSX Running High Workload Oracle 12c appeared first on Virtual Blocks.

Customers often ask whether InfiniBand (IB) can be used with vSphere. The short answer is, yes. VM Direct Path I/O (passthrough) allows InfiniBand cards to be made directly visible within a virtual machine so the guest operating system can directly access the device. With this approach, no ESX-specific driver is required — just the hardware […]

The post Performance of RDMA and HPC Applications in VMs using FDR InfiniBand on VMware vSphere appeared first on VMware | CTO Blog.

By Kelly Dare I recently spoke with Steve Wehrend, our VP of User Experience (UX) and User Interface (UI), about his role and the impact his group is making on the VMware customer experience. Steve’s objective is to make VMware UIs as transparent as possible. He describes his vision this way: “The best tools let […]

The post Improving the VMware User Experience Every Day appeared first on VMware TAM Blog.

Friends, Just wanted to call out one of the things we strongly believe in is raising awareness around women in technology, and more importantly, helping those who are just getting started in their college and work careers. Recently, an opportunity to make an impact on supporting women in technology came up with she++ Gala event […]

The post Continuing our efforts in raising awareness for Women in Technology - VMware Hands-on Labs appeared first on VMware Hands-On Lab (HOL) Blog.

Fujifilm’s Chief Storage Architect Esteban Rubens is delivering a very compelling architecture to improve patient care by simplifying their imaging platform using hyper-converged infrastructure powered byVMware SDDC. By using VxRail, new systems can be deployed in minutes, the ongoing maintenance is greatly simplified, and the total cost of the system is lower than alternative architectures.

The post Hyper-converged makes Fujifilm Synapse PACS a Snap appeared first on VMware for Healthcare IT.

The PostgreSQL Global Development Group announces today that the first beta release of PostgreSQL 9.6 is available for download. This release contains previews of all of the features which will be available in the final release of version 9.6, although some details will change before then. Users are encouraged to begin testing their applications against this latest release.

Major Features of 9.6

Version 9.6 includes significant changes and exciting enhancements including:

• Parallel sequential scans, joins and aggregates
• Support for consistent, read-scaling clusters through multiple synchronous standbys and "remote_apply" synchronous commit.
• Full text search for phrases
• postgres_fdw can now execute sorts, joins, UPDATEs and DELETEs on the remote server
• Decreased autovacuum impact on big tables by avoiding "refreezing" old data.

In particular, parallel execution should bring a noticeable increase in performance to supported queries.

Help Test for Bugs

As with other major releases, the improvements in PostgreSQL include changes to large amounts of code. We count on you to test the altered version with your workloads and testing tools in order to find bugs and regressions before the release of PostgreSQL 9.6.0. In addition to testing that the new features work as documented, consider testing the following:

• Do parallel queries actually improve performance for you?
• Can you make parallel queries crash or lose data?
• Do our code changes cause PostgreSQL to not function on your platform?
• Does improved vacuum freezing safely reduce autovacuum of large tables?
• Does phrase search return the results you expect?

Version 9.6 Beta 1 also makes changes to the binary backup API. Administrators should test version 9.6 with PostgreSQL backup tools, including pgBackRest, Barman, WAL-E, and other packaged and in-house software.

As this is a Beta, minor changes to database behaviors, feature details, and APIs are still possible. Your feedback and testing will help determine the final tweaks on the new features, so test soon. The quality of user testing helps determine when we can make a final release.

Beta Schedule

This is the first beta release of version 9.6. The PostgreSQL Project will release additional betas as required for testing, followed by one or more release candidates, until the final release in late 2016. For further information please see the Beta Testing page.

Links

• Downloads Page
• Beta Testing Information
• 9.6 Beta Release Notes
• What's New in 9.6
• 9.6 Open Items