Oxford, United Kingdom - May 4, 2017

2ndQuadrant is pleased to announce the release of pglogical 2.0 – the next generation in logical replication for PostgreSQL. This version will continue to be supported until EOL for PostgreSQL server versions 9.4, 9.5 and 9.6 and will also work with PostgreSQL 10 due to release in Fall 2017.

What's New

The pglogical 2.0 release brings new features allowing it to be used for even more use-cases. It also includes several bug fixes and behavior improvements, including:

• Row filter - specify SQL expression which should be used on upstream to filter rows for replicated table
• Column filter - specify list of columns that should be replicated, this allows replication of just some columns from a table
• Windows support - pglogical can be now used with PostgreSQL running on Windows as both provider and subscriber (has to be built from the source at the moment)
• Delayed replication - it’s now possible to set delay for how long behind the downstream should be when replicating data
• Postgres-XL support - Postgres-XL can become a pglogical subscriber, which means you can replicated from PostgreSQL to Postgres-XL directly
• New command line tool pglogical_create_subscriber which can convert physical standby (or base backup) into pglogical subscriber
• Performance improvements for applying transactions containing many INSERTs (including transactions that did large import using COPY)
• Improved behavior of TRUNCATE, especially the TRUNCATE triggers
• Users executing DDL in database no longer need USAGE privilege on pglogical schema
• Fixed reporting of false positives on UPDATE conflicts
• Log level for conflicts can now be changed

About pglogical

pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. This alternative to physical replication is a highly efficient method of replicating data using a publish/subscribe model for selective replication.

About 2ndQuadrant

2ndQuadrant leads the drive for improving the enterprise functionality for PostgreSQL, continuously contributing major features to every release for performance, replication, business intelligence and usability.

pglogical has been developed by 2ndQuadrant. It is open source and fully supported for 2ndQuadrant 24/7 Support customers. We also offer consulting services to help organizations with application development, conflict handler design, cluster design, deployment, feature development and performance analysis.

A months’ long journey for thousands of the world’s most promising high school students culminated last week in dual events hosted by FIRST Robotics – where they vied for $50 million in college scholarships. The 3,300 teams with 80,000-plus students from 25 countries who had begun the competition at the start of the school year […]

The post T-Minus Zero: FIRST Competition Finals Blast Off in Houston and St. Louis appeared first on The Official NVIDIA Blog.

Here at VMware AirWatch, we work hard to create a progressive culture that promotes cross-functional collaboration and fosters a strong drive to execute effectively. Last year, Tony Keuh saw an opportunity for our engineering, user experience (UX) and marketing teams to work even more efficiently together—and meet our customers&#rsquo; highest priority needs—when he joined […]

The post Building Great Technology Starts with Building a Great Team, Part 1 appeared first on VMware End-User Computing Blog.

?????? ?????, ????? ?????? ????????????? Bechtle AG, ??????????? ???????? VMware …

Read More

The public cloud has stepped out of the shadows and stretched across the solar system as organizations scale their usage of it to extend on-premises infrastructure, consolidate or migrate data centers, and support dynamic capacity requirements.   But many organizations also run apps and manage on-premise data in data centers and private clouds, and will

The post &#lsquo;May the 4thBe with You&#rsquo; on Your Journey to the Cloud appeared first on VMware vCloud.

I’ve talked about how vSphere has been moving towards a “secure by default” stance over the past few years. This can clearly be seen in the new vSphere 6.5 Security Configuration Guide where the number of “hardening” steps are growing smaller with every release. In this blog post we will go over another “secure by

The post Secure Boot for ESXi 6.5 - Hypervisor Assurance appeared first on VMware vSphere Blog.

We released PowerCLI 6.5.1 two weeks ago and the response has been incredible! The VMware.PowerCLI module is closing in on 4,000 downloads from the PowerShell Gallery and we&#rsquo;ve received a ton of good feedback. There seems to be quite a few questions and comments over this new installation method so I created a walkthrough video […]

The post PowerCLI 6.5.1 Installation Walkthrough appeared first on VMware PowerCLI Blog.

Introduction: vSAN continues its journey of growth with more than 7,000 customers have chosen to entrust their most important workloads to vSAN. To support this journey, we are committed to work with our partners and enable the next generation hardware platform for our mutual customers. Composable infrastructure is the next generation platform customers are adopting

The post HPE Synergy – the first composable infrastructure – now certified for vSAN appeared first on Virtual Blocks.

To check the pulse on how AI is transforming the healthcare industry, look no further than the eighth annual GPU Technology Conference, next week at the San Jose Convention Center. GTC’s healthcare track will offer 50-plus sessions detailing the latest thinking on how AI and deep learning are empowering physicians to do more in such […]

The post At GTC, Taking the Temperature of How AI Is Transforming Healthcare appeared first on The Official NVIDIA Blog.

Roland König, Head of Virtualization at Bechtle AG, …

Read More

These days, every company has cloud adoption square in their sights. And frankly, it&#rsquo;s a matter of survival. But making the switch to the public cloud is difficult, weighted by legacy systems and incompatible architecture. Fortunately, virtualization may hold the key to success.   In the latest edition of our Partner Spotlight series, VMware Service

The post Partner Spotlight: NTT&#rsquo;s Virtual Infrastructure Makes the Switch to the Public Cloud Even Easier appeared first on VMware vCloud.

Oracle Database 12c on VMware vSAN — Day 2 Operations and Management Customers deploying production Oracle workloads have stringent requirements to support and maintain critical database operational tasks such as Backup and Recovery, Cloning, Data Refresh for Development/Test environment and Patching. These operational tasks are also known as Database Day 2 Management Operations. With the […]

The post Oracle Database 12c on VMware vSAN — Day 2 Operations and Management appeared first on Virtualize Business Critical Applications.

Customers deploying production Oracle workloads have stringent requirements to support and maintain critical database operational tasks such as Backup and Recovery, Cloning, Data Refresh for Development/Test environment and Patching. These operational tasks are also known as Database Day 2 Management Operations. With the rapid adoption of VMware vSAN™ for business-critical workloads due to highly scalable,

The post Oracle Database on VMware vSAN Day 2 Operations and Management – Operation Guide appeared first on Virtual Blocks.

Register now for VMworld 2017 Europe!

The countdown to VMworld 2017 …

Read More