Posts Tagged "postgresql repmgr"

repmgr 3.3

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…

Barman 2.1 and the new –archive option

Barman 2.1 Version 2.1 of Barman, backup and recovery manager for PostgreSQL, was released Thursday, Jan. 5. The new release, along with several bugfixes, introduces preliminary support for the upcoming PostgreSQL 10, and adds the –archive option to the switch-xlog command. switch-xlog –archive The new –archive option is especially useful when setting up a new…

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

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

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…

Conference isn’t enough?! Join us for post-conference training!

Did you know – 2ndQuadrant has the largest single, collection of PostgreSQL experts of any company globally?! With a team of some of the best known developers, they all still actively contribute to the progressive development of PostgreSQL. Would you like to have access to some of the most knowledgeable and experienced people available? The…

5432…MeetUs! Conference Gives Opportunities for Meaningful Takeaways

If you are eager to learn new competencies or advance your skills in PostgreSQL and other Open Source programs, platforms, and languages, you should join us at the 5432…MeetUs! conference! Between the workshop track offered during the conference and the optional trainings offered in the two days following the conference, it looks like there will be something…

Announcing repmgr 2.0RC2

Version 2.0RC2 of repmgr, Replication Manager for PostgreSQL clusters, has been released. This release introduces a new experimental feature, autofailover. With autofailover repmgr is able to automatically promote a standby and let the other standbys follow the new master, without interaction of the DBA. It also adds a lot of bug fixes and several new…

Announcing repmgr 2.0RC1

Version 2.0RC1 of repmgr, Replication Manager for PostgreSQL clusters, has been released. This release introduces a new experimental feature, autofailover. With autofailover repmgr is able to automatically promote a standby and let the other standbys follow the new master, without interaction of the DBA. It also adds a lot of bug fixes and several new…

Managing useful clusters with repmgr

To create a standby in PostgreSQL is relatively easy, and because of the hot standby feature, that alone is certainly very useful. But creating a useful cluster that gives us real HA… that’s another story. The complexities added by failure detection, STONITH rules and choosing a new master could be overwhelming. But still, it is…

How not to build PostgreSQL 9.0 extensions on RPM platforms

For a long time, adding packages to RedHat derived Linux systems has been called “RPM Hell”, for good reason.  Particularly before the yum utility came about to help, getting RPM to do the right thing has often been a troublesome task.  I was reminded of this again today, while trying to compile a PostgreSQL extension…