Since PostgreSQL 9.5, pg_rewind has been able to make a former master follow up a promoted standby although, in the meantime, it proceeded with its own timeline. Consider, for instance, the case of a switchover that didn’t work properly. Have you ever experienced a "split brain" during a switchover operation? You know, when the goal […]
The Best Barman Ever
/0 Comments/in 2ndQuadrant, Featured, Gabriele's PlanetPostgreSQL /by Gabriele BartoliniThis is my (very) biased opinion, but I am ready to bet that once you try Barman 2.0 you’ll agree with me.
BDR is coming to PostgreSQL 9.6
/39 Comments/in Craig's PlanetPostgreSQL /by craig.ringerI’m pleased to say that Postgres-BDR is on its way to PostgreSQL 9.6, and even better, it works without a patched PostgreSQL. BDR has always been an extension, but on 9.4 it required a heavily patched PostgreSQL, one that isn’t fully on-disk-format compatible with stock community PostgreSQL 9.4. The goal all along has been to […]
Those darn Large Objects
/3 Comments/in PostgreSQL /by Martín MarquésIntro PostgreSQL gives developers the chance of choosing between two possible storage facilities for large binary data: Bytea and LargeObjects. Large Objects have been around for a long time, and PostgreSQL has a smart way of storing large binary data. It does so by splitting it into chunks of LOBLKSIZE (a forth of BLCKSZ). That […]
My experience with the Indonesia PUG meetup
/0 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidI was in Jakarta a couple of weeks ago and there happened to be a meetup of the Indonesia PUG in Bandung while I was there. Because it is just a 2 hour, rather picturesque drive, from Jakarta, I thought it was too good of an opportunity to miss. So I showed up. The meetup was hosted […]
Back to the Future Pt. 1: Introduction to pg_rewind
/14 Comments/in 2ndQuadrant, Featured, Giuseppe's PlanetPostgreSQL /by 2ndQuadrant PressSince PostgreSQL 9.5, pg_rewind has been able to make a former master follow up a promoted standby although, in the meantime, it proceeded with its own timeline. Consider, for instance, the case of a switchover that didn’t work properly. Have you ever experienced a "split brain" during a switchover operation? You know, when the goal […]
PostgreSQL 9.1 End of Life
/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsAs you may have seen, PostgreSQL 9.1 has now reached its End of Life. That means the last maintenance update of 9.1 will be in November 2016. PostgreSQL 9.6 is currently due out in September 2016, so you have a chance to move from PostgreSQL 9.1 to PostgreSQL 9.6. Supported upgrade choices are pg_upgrade pg_dump […]
When to use Postgres-BDR or Postgres-XL?
/1 Comment/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsThe right answer is of course “Use PostgreSQL”. It’s the main distro and we want you to use that as often as possible. The Postgres-BDR and Postgres-XL projects are also fully open source projects, using the same copyright and licence as the main PostgreSQL project. So if you’re using PostgreSQL, they are also options to […]
Postgres-BDR: 2 Years in Production
/1 Comment/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsPostgres-BDR has now reached 1.0 production status. Over the last 2 years, Postgres-BDR has been used daily for mission critical production systems. As you might imagine, it’s been improved by both bug fixes and feature enhancements that allow it to be used smoothly, so its mature, robust and feature-rich. The BDR Project introduced logical replication […]
Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit
/3 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin YildirimPostgreSQL is an awesome project and it evolves at an amazing rate. We’ll focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions with a series of blog posts. This is the fourth post of the series and we’ll talk about synchronous commit and its effects on fault tolerance and dependability of PostgreSQL. […]
BDR 1.0
/7 Comments/in Craig's PlanetPostgreSQL /by craig.ringerI’m pleased to say that we’ve just released Postgres-BDR 1.0, based on PostgreSQL 9.4.9. This release contains significant improvements to DDL replication locking, global sequences, documentation, performance, and more. It also removes the deprecated UDR component in favour of