Ian's PlanetPostgreSQL Archives - 2ndQuadrant

Replication configuration changes in PostgreSQL 12

October 7, 2019/0 Comments/in Ian's PlanetPostgreSQL, repmgr /by Ian Barwick

Historically, PostgreSQL’s replication configuration has been managed via a configuration parameters stored in a dedicated configuration file, recovery.conf, which has been present in PostgreSQL since the introduction of archive recovery in PostgreSQL 8.0. One of the major changes in PostgreSQL 12, co-authored by 2ndQuadrant is the replacement of recovery.conf and the conversion of recovery.conf parameters […]

repmgr 3.3

January 26, 2017/0 Comments/in Ian's PlanetPostgreSQL /by Ian Barwick

repmgr 3.3 introduces a number of additional options for setting up and managing replication clusters, with particular emphasis on cascading replication support. These changes will also make it easier to set up complex clusters using provisioning scripts. Additionally there are changes to the repmgr command line utility’s logging behaviour which you should take into consideration […]

repmgr 3.2 is here with Barman support and Brand New High Availability features

October 10, 2016/0 Comments/in Ian's PlanetPostgreSQL, repmgr /by Ian Barwick

repmgr 3.2 has recently been released with a number of enhancements, particularly support for 2ndQuadrant’s Barman archive management server, additional cluster monitoring functionality and improvements to the standby cloning process. One aim of this release is to remove the requirement to set up passwordless SSH between servers, which means when using repmgr’s standard functionality to […]

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 […]

Letter from Japan

June 22, 2016/0 Comments/in Ian's PlanetPostgreSQL /by Ian Barwick

Greetings, honourable reader. My name is Barwick of the 2ndQuadrant Company. With the onset of the Plum Rain, in my humble estimation it has become hot and humid recently. I trust all is well in your exalted undertakings? No, I haven’t flipped a bit – the above is actually pretty much how a Japanese business […]

Japan PostgreSQL Conference 2014

December 11, 2014/0 Comments/in Ian's PlanetPostgreSQL /by Ian Barwick

Japan has been an early and vigorous adopter of PostgreSQL (back in 2006, when PostgreSQL was still emerging from obscurity in the western hemisphere, I noted that in Tokyo bookstores, PostgreSQL books outweighed MySQL ones by about 5:3), and it’s no surprise that by nationality, only the USA and Germany have more committers. The Japan […]

2ndQuadrant is now part of EDB

Replication configuration changes in PostgreSQL 12

repmgr 3.3

repmgr 3.2 is here with Barman support and Brand New High Availability features

Improvements in repmgr 3.1.4

Letter from Japan

Japan PostgreSQL Conference 2014

Support & Services

Products

Postgres Learning Center

About Us