replication Archives - Page 4 of 4 - 2ndQuadrant

Posts

Performance limits of logical replication solutions

January 20, 2016/5 Comments/in 2ndQuadrant, pglogical, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

In the previous blog post, I briefly explained how we got the performance numbers published in the pglogical announcement. In this blog post I’d like to discuss the performance limits of logical replication solutions in general, and also how they apply to pglogical. physical replication Firstly, let’s see how physical replication (built into PostgreSQL since […]

Getting WAL files from Barman with ‘get-wal’

October 6, 2015/1 Comment/in Barman, Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

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 reasons behind this feature and briefly describe it. One of the initial ideas we had in mind when conceiving Barman was to make it, one […]

BDR for PostgreSQL: Present and future

December 8, 2014/11 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

For a couple of years now a team at 2ndQuadrant led by Andres Freund have been working on adding bi-directional asynchronous multi-master replication support for PostgreSQL. This effort has become known as the BDR project. We’re really excited to see these efforts leading to new PostgreSQL features and have a great deal more still to […]

Progress on online upgrade

November 28, 2014/4 Comments/in Petr's PlanetPostgreSQL, PostgreSQL /by Petr Jelinek

In last couple of months I’ve been working on online upgrade for very large databases as part of the AXLE project and I would like to share my thoughts on the topic and what progress we have made recently. Before joining 2ndQuadrant I used to work in Skype where the business would not allow a […]

Streaming replication slots in PostgreSQL 9.4

February 25, 2014/15 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

Streaming replication slots are a pending feature in PostgreSQL 9.4, as part of the logical changeset extraction feature. What are they for, what do you need to know, what changes? What are replication slots? Streaming replication slots are a new facility introduced in PostgreSQL 9.4. They are a persistent record of the state of a […]

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

Posts

Performance limits of logical replication solutions

Getting WAL files from Barman with ‘get-wal’

BDR for PostgreSQL: Present and future

Progress on online upgrade

Streaming replication slots in PostgreSQL 9.4

Support & Services

Products

Postgres Learning Center

About Us