Tuesday, October 24

Tag: postgresql repmgr

repmgr 3.3

Ian's PlanetPostgreSQL
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 when running therepmgrd daemon. repmgr is also tracking developments in the next major PostgreSQL release, 10.0, which will bring a lot of changes to the way PostgreSQL handles replication. At the time of writing, repmgr will work with the current PostgreSQL development code, but this combination is of course not suitable for use in production. Changes to logging behaviour Traditionally the repmgr command (more…)

Barman 2.1 and the new –archive option

Giulio's PlanetPostgreSQL
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 server. Until now, the switch-xlog command used to force the PostgreSQL server to switch to a different transaction log file. Now, Barman also gives the --archive option, which triggers WAL archiving after the xlog switch, and forces Barman to wait for the archival of the closed WAL file. By default Barman expects to receive the WAL in 30 seconds, the amount of seconds to wait can be changed using the --archive-timeout (more…)

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

Ian's PlanetPostgreSQL, repmgr
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 clone a standby, this is no longer a prerequisite. However, some advanced operations do require SSH access to be enabled. Barman support repmgr 3.2 can now clone a standby directly from the Barman backup and recovery manager. In particular it is now possible to clone a standby from a Barman archive, rather than directly from a running database server. This means the server is not subjected to the I/O (more…)

Improvements in repmgr 3.1.4

Ian's PlanetPostgreSQL
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 a more robust replication setup by enabling PostgreSQL to fall back to a WAL archive source if streaming replication is interrupted. See Gabriele Bartolini's recent blog post "Speed up getting WAL files from Barman" for an example on how to do this. CSV output for repmgr cluster show The repmgr cluster show command now accepts the optional parameter --csv, which outputs the status of the (more…)
Conference isn’t enough?!  Join us for post-conference training!

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

2ndQuadrant, International News
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! post-conference training is your chance! In addition to the Kanban System Design training course with Dragos Dumitriu we mentioned last week, there will be a variety of other training courses in the days following the 5432...MeetUs! conference.  When you attend a course with 2ndQuadrant, you learn from experts who understand PostgreSQL, the platforms, programs, and languages at the deepest level. Learn in depth about the (more…)
5432…MeetUs! Conference Gives Opportunities for Meaningful Takeaways

5432…MeetUs! Conference Gives Opportunities for Meaningful Takeaways

2ndQuadrant, Britt's PlanetPostgreSQL, International News
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 for everyone at this conference. There's a chance to be hands-on with different programs, platforms and languages such as Docker, Repmgr and more - we also hear that they will have some Raspberry Pis that you can experiment with. The workshops are an optional track during the conference (it is required that you register in advance) and the trainings will be held in the days following the conference. Some of our very (more…)

Announcing repmgr 2.0RC2

Christian's PlanetPostgreSQL, PostgreSQL, repmgr
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 features. Read the full announcement at http://repmgr.org/release-notes-2.0RC2.html. About repmgr repmgr is a set of open source tools that helps DBAs and System administrators manage a cluster of PostgreSQL databases. By taking advantage of the Hot Standby capability introduced in PostgreSQL 9, repmgr greatly simplifies the process of setting up and managing database with high availability and scalability requirements. repmgr (more…)

Announcing repmgr 2.0RC1

Christian's PlanetPostgreSQL, repmgr
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 features. Read the full announcement at http://repmgr.org/release-notes-2.0RC1.html. About repmgr repmgr is a set of open source tools that helps DBAs and System administrators manage a cluster of PostgreSQL databases. By taking advantage of the Hot Standby capability introduced in PostgreSQL 9, repmgr greatly simplifies the process of setting up and managing database with high availability and scalability requirements. repmgr (more…)

Managing useful clusters with repmgr

Jaime's PlanetPostgreSQL
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 an important part of maintaining a healthy PostgreSQL environment. Repmgr 2.0 gives you the opportunity to configure a more streamlined failover process for when you need it. Repmgr 2.0 was released as a beta about a month ago, and we incorporated many feature requests received from the community. If you requested something of the tool which didn’t make it into this release, keep on us, as we’ve been working hard to insure we a had release out prior to 9.2 (more…)

How not to build PostgreSQL 9.0 extensions on RPM platforms

Greg's PlanetPostgreSQL, PostgreSQL, United Kingdom News, United States News
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 on two nearly identical CentOS systems.PostgreSQL provides an API named PGXS that lets you build server extensions that both leverage the code library of the server and communicate with it.  We use PGXS to install our repmgr utility, and having that well defined API let the program be developed externally from the main server core.  Many popular pieces of PostgreSQL add-ons rely on PGXS to build themselves.  In fact, the contrib modules that come with (more…)