replication Archives - Page 3 of 4 - 2ndQuadrant

Posts

Thoughts on Uber’s List of Postgres Limitations

August 2, 2016/8 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

An Uber technical blog of July 2016 described the perception of “many Postgres limitations”. Regrettably, a number of important technical points are either not correct or not wholly correct because they overlook many optimizations in PostgreSQL that were added specifically to address the cases discussed. In most cases, those limitations were actually true in the […]

Improvements in repmgr 3.1.4

July 25, 2016/0 Comments/in Ian's PlanetPostgreSQL /by Ian Barwick

The recently released repmgr 3.1.4 update incorporates several changes which improve usability and lay out the groundwork for enhanced compatibility with 2ndQuadrant’s barman product. New configuration option restore_command It’s now possible to specify a restore_command in repmgr.conf, which will be included in the recovery.conf file generated by repmgr standby clone, making it easier to configure […]

Evolution of Fault Tolerance in PostgreSQL: Time Travel

July 21, 2016/0 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim

PostgreSQL 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 third post of the series and we’ll talk about timeline issues and their effects on fault tolerance and dependability of PostgreSQL. […]

Speed up getting WAL files from Barman

July 19, 2016/0 Comments/in Featured, Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

Starting from Barman 1.6.1, PostgreSQL standby servers can rely on an “infinite” basin of WAL files and finally pre-fetch batches of WAL files in parallel from Barman, speeding up the restoration process as well as making the disaster recovery solution more resilient as a whole. The master, the backup and the standby Before we start, […]

Evolution of Fault Tolerance in PostgreSQL: Replication Phase

July 11, 2016/0 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim

PostgreSQL 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 second post of the series and we’ll talk about replication and its importance on fault tolerance and dependability of PostgreSQL. If […]

Evolution of Fault Tolerance in PostgreSQL

July 4, 2016/0 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim

“It is paradoxical, yet true, to say, that the more we know, the more ignorant we become in the absolute sense, for it is only through enlightenment that we become conscious of our limitations. Precisely one of the most gratifying results of intellectual evolution is the continuous opening up of new and greater prospects.” Nikola Tesla […]

PGLogical 1.1 packages for PostgreSQL 9.6beta1

May 12, 2016/0 Comments/in 2ndQuadrant, Petr's PlanetPostgreSQL, pglogical, PostgreSQL /by Petr Jelinek

We have made pglogical 1.1 packages available for PostgreSQL 9.6beta1 for both rpm and deb based distributions. They are available for install from our standard pglogical package repository. You may ask why do we release packages for beta version of Postgres? Well, one of the reasons is that you can use pglogical to replicate your […]

PGLogical 1.1 released with sequence support and more

May 2, 2016/0 Comments/in Petr's PlanetPostgreSQL, pglogical /by Petr Jelinek

The new feature version of pglogical is now available. The new release brings support for sequence replication, manually configured parallel subscriptions, replica triggers, numerous usability improvements and bug fixes. Let’s look into the changes in more detail.

And Barman 1.6.0 is out!

March 8, 2016/2 Comments/in Featured, Rubens' PlanetPostgreSQL /by Rubens Souza

Good news has come out to ensure your disaster recovery strategy is even better! Wait…what?! You don’t have a disaster recovery strategy?! No good, my friend, no good…

FLOSS UK Spring Conference

February 22, 2016/0 Comments/in 2ndQuadrant, Gulcin's PlanetPostgreSQL, pglogical, PostgreSQL, United Kingdom News /by Gulcin Yildirim

Floss UK Spring conference will be held on 15th-17th of March in London.

Read 2ndQuadrant’s response to the COVID – 19 emergency here