My colleagues and I are often asked “when will you (2ndQuadrant) contribute BDR to PostgreSQL?” This makes an interesting assumption: that we have not already done so. We have. Much...
2ndQuadrant is proud to announce the release of version 1.5.1 of Barman, Backup and Recovery Manager for PostgreSQL. This minor release introduces support for ‘per-server’ concurrency of maintenance operations through...
As you may have noted from my previous blog, the last few months were busy in getting Postgres-XL up-to-date with the latest 9.5 release of PostgreSQL. Once we had a...
EnterpriseDB (EDB) customers who moved/migrated their database from Oracle to EDB’s Postgres Plus Advanced Server (PPAS) frequently ask for Global Temporary Table in PPAS. Currently, PPAS doesn’t support Global Temporary...
Ansible is simply great and PostgreSQL is surely awesome, let’s see how they work amazingly together! ==================== Prime time announcement ! ==================== PGConf Europe 2015 will be on 27th-30th of...
A lot is being said about the new ‘tablesample’ feature of PostgreSQL 9.5. The ability to retrieve a random sample of data in a short amount of time from a...
As people have been working on merging Postgres-XL with the PostgreSQL 9.5 branch, I’ve been trying out Postgres-XL’s ability to run a decision support-like workload. The DBT-3 test kit, originally...
Barman 1.5.0 enhances the robustness and business continuity capabilities of PostgreSQL clusters, integrating the get-wal command with any standby server’s restore_command. In this blog article I will go over the...
Version 1.5.0 of Barman, Backup and Recovery Manager for PostgreSQL, has been released. Barman is now able to return upon request any available WAL file for a given server, allowing...