The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.2, 9.4.7, 9.3.12, 9.2.16, and 9.1.21. This release fixes two security issues and one index corruption issue in version 9.5. It also contains a variety of bug fixes for earlier versions. Users of PostgreSQL 9.5.0 or 9.5.1 should update as soon as possible.

Security Fixes for RLS, BRIN

This release closes security hole CVE-2016-2193, where a query plan might get reused for more than one ROLE in the same session. This could cause the wrong set of Row Level Security (RLS) policies to be used for the query.

The update also fixes CVE-2016-3065, a server crash bug triggered by using pageinspect with BRIN index pages. Since an attacker might be able to expose a few bytes of server memory, this crash is being treated as a security issue.

Abbreviated Keys and Corrupt Indexes

In this release, the PostgreSQL Project has been forced to disable 9.5's Abbreviated Keys performance feature for many indexes due to reports of index corruption. This may affect any B-tree indexes on TEXT, VARCHAR, and CHAR columns which are not in "C" locale. Indexes in other locales will lose the performance benefits of the feature, and should be REINDEXed in case of existing index corruption. The feature may be re-enabled in future versions if the project finds a solution for the problem. See the release notes, and the wiki page on this issue for more information.

Other Fixes and Improvements

In addition to the above, many other issues were patched in this release based on bugs reported by our users over the last few months. This includes bugs which affect multiple versions of PostgreSQL, such as:

• Fix two bugs in indexed ROW() comparisons
• Avoid data loss due to renaming files
• Prevent an error in rechecking rows in SELECT FOR UPDATE/SHARE
• Fix bugs in multiple json_ and jsonb_ functions
• Log lock waits for INSERT ON CONFLICT correctly
• Ignore recovery_min_apply_delay until reaching a consistent state
• Fix issue with pg_subtrans XID wraparound
• Fix assorted bugs in Logical Decoding
• Fix planner error with nested security barrier views
• Prevent memory leak in GIN indexes
• Fix two issues with ispell dictionaries
• Avoid a crash on old Windows versions
• Skip creating an erroneous delete script in pg_upgrade
• Correctly translate empty arrays into PL/Perl
• Make PL/Python cope with identifier names

This update also contains tzdata release 2016c, with updates for Azerbaijan, Chile, Haiti, Palestine, and Russia, and historical fixes for other regions.

Updating

Users of version 9.5 will want to REINDEX any indexes they created on character columns in non-C locales. Users of other versions who have skipped multiple update releases may need to perform additional post-update steps; see the Release Notes for details.

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.

Links:

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

GPU startup MapD is on a roll. The big data analytics company, which won our first $100,000 Early Stage Challenge in 2014, today unveiled its visual analytics software that uses GPUs to crunch large datasets at lightning speeds. The MapD database uses GPUs to process SQL queries in parallel across nearly 40,000 cores per server, yielding […]

The post MapD Lands $10M Investment, Launches Real-time Database appeared first on The Official NVIDIA Blog.

Business mobility has evolved, and much has been said about …

Read More

The Cross-VC NSX feature introduced in VMware NSX 6.2, allows for NSX logical networking and security support across multiple vCenters. Logical switches (LS), distributed logical routers (DLR) and distributed firewall (DFW) can now be deployed across multiple vCenter domains. These Cross-VC NSX objects are called Universal objects. The universal objects are similar to distributed logical […]

The post Cross-VC NSX for Multi-site Solutions appeared first on The Network Virtualization Blog.

VMware announced the first step towards making a HTML5 Web Client areality, thevSphere HTML5 Web Client Fling. This first releaseof the Fling will focus primarily on VM management, with more updates coming. Here is a list of the features and operations available in this first release: VM power operations VM Edit Settings (simple CPU, Memory, […]

The post vSphere HTML5 Web Client Fling – Getting Started appeared first on VMware vSphere Blog.

Unveil VMware Customer Reviews about Cost Savings using vRealize Operations Wondering how to achieve cost savings with vRealize Operations? Lets take a look at this Data Center environment. Exhibit below. This is a quick snapshot of our data center using vRealize Operations and specifically we are looking at your opportunity to reclaim capacity to save […]

The post Unveil VMware Customer Reviews about Cost Savings appeared first on VMware Cloud Management.

Företagsmobilitet, eller mobilitetslösningar för företag, har kommit till att kräva …

Read More

by Paige Handza, End-User Computing retail solutions, VMware Just the other day, I was asked, “What brought you to VMware?” I was shocked when I did not have an answer right away. Don’t get me wrong; there were lots of reasons going through my head, including the great culture, integrity of the people and cutting-edge […]

The post Top Tech Trends in Retail: IT Leaders Reveal their Biggest Priorities appeared first on VMware End-User Computing Blog.

The Radicati Group today released its Enterprise Mobility Management (EMM) Market Quadrant 2016. The technology research firm annually reviews the top players in the global EMM market, evaluating technologies based on features, pricing, market share, partner ecosystem and global support. Among the 13 EMM providers included in the evaluation, VMware AirWatch earned the top spot […]

The post Radicati Recognizes AirWatch as ‘Top Player’ in 2016 Market Quadrant appeared first on VMware Radius.

In just a few short days, my teammates and I will be heading off to Kennesaw, Georgia with one goal in mind – hire professional selling majors for the 2016 U.S. VMware Sales Academy at the National Collegiate Sales Competition (NCSC). Based in the lively city of Austin, Texas, the VMware Sales Academy is a […]

The post The National Collegiate Sales Competition: How a Community of Students is Transforming Customer Success appeared first on VMware Careers Blog.

Last week, we described how vCloud Air is a public cloud designed especially for IT, solving a unique set of problems that cannot be addressed by other public clouds. In this blog, we will take a closer look at one of these use cases: Data Center Replacement. Replacing an existing data center is a major […]

The post Replacing Your Data Center is Simple with vCloud Air appeared first on VMware vCloud Air Blog.

We are extending SDS provisional status through August, 2016 to allow more of you to take the soon-to-be-released VSP, VTSP and ICM training in the May-June timeframe. Meanwhile, be sure to keep your knowledge of Virtual SAN and VMware Hyperconverged Software up-to-date to win more deals.

The post SDS Provisional Status - Extension appeared first on Partner News.

It’s getting closer! This year we’re the proud DevOps Partner …

Read More

The Radicati Group released its annual Enterprise Mobility Management (EMM) Market Quadrant today, with VMware AirWatch continuing its five-year streak at the top of the rankings. Get your complimentary copy of the Radicati EMM Market Quadrant here. Every year, the technology market research leader looks at the top EMM providers worldwide and evaluates them based […]

The post Radicati Puts VMware AirWatch at the Top of New EMM Quadrant appeared first on VMware End-User Computing Blog.

By Craig Savage: In my role as an Operations Transformation Architect, I get the privilege of working with many different organisations in many different markets and geographies, and as our team are closely knit, we share a lot of knowledge and experience amongst ourselves and globally after each engagement we undertake. What follows are some […]

The post Surviving Change: 12 Organisation Transformation Principles to Help You Cope appeared first on VMware Operations Transformation Services.

A new version of the Deployment and Design Considerations for VMware Mirage white paper includes material for new Mirage features and components, such as MongoDB databases, and includes many small improvements that make the material more accessible.

The post Deployment and Design Considerations for VMware Mirage 5.7 appeared first on VMware End-User Computing Blog.

SANTA CLARA, CA - NVIDIA (NASDAQ: NVDA) will present at the following upcoming event for the financial community:

Everything changed for VR startups two years ago when Facebook announced it would pay $2 billion for headset-maker Oculus. Facebook’s big bet was the signal other investors needed. Since then, venture capital deals and dollars invested in virtual and augmented reality have tripled, according CB Insights, a venture capital research firm. Venture investment in VR and AR reached […]

The post Eight VR Startups to Watch at the Emerging Companies Summit appeared first on The Official NVIDIA Blog.