You are here

PostreSQL.org

Subscribe to PostreSQL.org feed
PostgreSQL news
Updated: 2 days 3 hours ago

Announcing The Release Of repmgr 4.0.2

2018, January 18 - 01:00

Oxford, United Kingdom - January 18, 2018

2ndQuadrant announces the release of repmgr 4.0.2. repmgr is the most popular tool for PostgreSQL replication and failover management. It enhances and complements PostgreSQL's built-in replication capabilities, making it easy to set up and manage standby servers, check replication status, and perform administrative tasks such as switchover operations. The repmgrd daemon provides automatic failover capability to maximize database uptime and can easily be integrated with other tools such as PgBouncer for high application availability.

repmgr 4.0.2 includes the following usability enhancements:

  • Recognize the -t/--terse option for repmgr cluster event to hide the Details column
  • Add "--wait-start" option for repmgr standby register
  • Add %p event notification parameter for repmgr standby switchover

This release contains the following bug fixes:

  • Add missing -W option to getopt_long() invocation
  • Automatically create slot name if missing
  • Fixes to parsing output of remote repmgr invocations
  • When registering BDR nodes, automatically create missing connection replication set
  • Handle missing node record in repmgr node rejoin

For a detailed list of all fixed bugs, please read the full release notes here.

We highly recommend upgrading to repmgr 4.0.2 at the earliest opportunity available. For this release, a simple package upgrade and restart of repmgrd (if running) is required.

Download is available here and installation instructions are available here.

repmgr is developed and maintained by 2ndQuadrant. It is fully supported by their respected 24/7 Production Support, providing the fastest and highest rated response service for PostgreSQL anywhere and is available worldwide. repmgr is distributed under GPL v3.

For more information, please send an email to info@2ndQuadrant.com

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and 5 continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. We have adopted the open source business model and are Major Sponsors for the PostgreSQL project. Our focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Categories: Informatika

pg_back 1.4 released

2018, January 18 - 01:00

pg_back is a simple (well kind of) bash shell script that can dump all your databases to files.

It can operate on standby servers and takes care of pausing and resuming WAL replay.

The 1.4 release brings support for PostgreSQL 10.

pg_back is licensed under the classic 2 clauses BSD license.

More at https://github.com/orgrim/pg_back

Categories: Informatika

JDBC 42.2.0 Released

2018, January 18 - 01:00

The JDBC group is proud to release version 42.2.0

Notable changes include:

  • Support SCRAM-SHA-256 for PostgreSQL 10 in the JDBC 4.2 version (Java 8+) using the Ongres SCRAM library. PR 842
  • Make SELECT INTO and CREATE TABLE AS return row counts to the client in their command tags. Issue 958 PR 962
  • Support Subject Alternative Names for SSL connections. PR 952
  • Support isAutoIncrement metadata for PostgreSQL 10 IDENTITY column. PR 1004
  • Support for primitive arrays PR#887 3e0491a
  • Implement support for get/setNetworkTimeout() in connections. PR 849
  • Make GSS JAAS login optional, add an option "jaasLogin" PR 922 see [Connecting to the Database]{https://jdbc.postgresql.org/documentation/head/connect.html
Categories: Informatika

Announcing the Release of OmniDB 2.4.1

2018, January 16 - 01:00

Oxford, United Kingdom — January 16, 2018

2ndQuadrant announces the release of OmniDB 2.4.1. OmniDB is a browser-based database management tool. It is designed to be a powerful, yet lightweight, user-friendly and fast-performing interface for PostgreSQL databases. OmniDB is fully backed by 2ndQuadrant’s world-renowned 24/7 Production Support.

The updates and improvements included in this release are:

  • Connections are now managed in the workspace, without losing existing work and focus
  • Autocomplete shortcut key is now Ctrl-Space by default
  • New improved Find & Replace for SQL Editor
  • OmniDB server now listens to the same port for HTTP(S) and WS(S), no need for opening two ports in firewall anymore

This release presents bug fixes including:

  • Improved autocomplete event handling
  • Data grid can now copy more than 1000 rows/cols
  • Improved performance for list sequence in tree view

For a complete list of changes, read the OmniDB change tracker here.

OmniDB 2.4.1 download is available here and installation instructions are available here.

For more information, please send an email to info@2ndQuadrant.com

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and 5 continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. We have adopted the open source business model and are Platinum sponsors for the PostgreSQL project. Our focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Categories: Informatika

Announcing the Release of pglogical 2.1.1

2018, January 11 - 01:00

Oxford, United Kingdom - January 11, 2018

2ndQuadrant announces the release of pglogical 2.1.1, the next generation in logical replication, for PostgreSQL. Implemented entirely as a PostgreSQL extension, pglogical is a logical replication system that serves as a highly efficient method of replicating data as an alternative to physical replication.

This is a minor release that addresses bugs including:

  • Fixed version detection for PostgreSQL 10.x releases
  • Fixed misreporting of conflicts on partial unique indexes
  • Fixed conflicts resulting from table synchronization. These could happen when synchronization worker has finished faster than main apply worker catches up with it.
  • Workaround for failure to clean spilled transactions in PostgreSQL
  • Log more context when reporting ERRORs
  • Log conflicting rows as part of conflict logging

pglogical is supported by 2ndQuadrant. 2ndQuadrant’s respected 24/7 Production Support provides the fastest and highest rated response service for PostgreSQL anywhere and is available worldwide.

Download and installation instructions are available here.

For more information, please send an email to info@2ndQuadrant.com

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and 5 continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. We have adopted the open source business model and are Platinum sponsors for the PostgreSQL project. Our focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Categories: Informatika

Pgpool-II 3.7.1, 3.6.8, 3.5.12, 3.4.15 and 3.3.19 are now officially released.

2018, January 9 - 01:00
What is Pgpool-II?

Pgpool-II is a tool to add useful features to PostgreSQL, including:

  • connection pooling
  • load balancing
  • automatic fail over and more.
Minor releases

Pgpool Global Development Group is pleased to announce the availability of following versions of Pgpool-II:

  • 3.7.1
  • 3.6.8
  • 3.5.12
  • 3.4.15
  • 3.3.19

These are the latest stable minor versions of each major versions of Pgpool-II. Release notes for versions prior 3.6 are no longer included in the source code.

Please take a look at release notes.

You can download the source code and RPMs.

Categories: Informatika

Announcing @postgresql

2018, January 8 - 01:00

The PostgreSQL Global Development Group is pleased to announce the launch of the official community Twitter handle: https://twitter.com/postgresql

@postgresql will contain a mix of automatic and manually curated postings from a group of volunteers that feature various aspects of PostgreSQL and the community-at-large. Content will contain a mix of news, advice, and highlights around PostgreSQL, and enable the PostgreSQL Global Development Group to further engage with the community. If you would like for @postgresql to highlight PostgreSQL-oriented content, we encourage you to reach out to @postgresql via Twitter’s direct message feature.

The live feed for blog entries syndicated from Planet PostgreSQL will continue to be available at https://twitter.com/planetpostgres

We hope you will join us on Twitter.

Categories: Informatika

pg_chameleon 2.0 released

2018, January 1 - 01:00

The version 2.0 of pg_chameleon the MySQL to PostgreSQL replica system is now available.

Several improvements come with this new milestone which is compatible with python 3.3+.

  • Replicates multiple MySQL schemas within the same MySQL cluster into a target PostgreSQL database. The source and target schema names can be different.
  • Conservative approach to the replica. Tables which generate errors are automatically excluded from the replica.
  • Daemonised init_replica,refresh_schema,sync_tables processes.
  • Daemonised replica process with two separated subprocess, one for the read and one for the replay.
  • Soft locking replica initialisation. The tables are locked when needed and stored with their log coordinates. The replica daemon puts the database in a consistent status gradually.
  • Rollbar integration for a simpler error detection and alerting.
  • Basic support for the PostgreSQL to PostgreSQL replica (EXPERIMENTAL)
  • Detach replica from MySQL for easy migration to PostgreSQL
Usage examples
  • Analytics
  • Migrations
  • Data aggregation from multiple MySQL databases
Download and documentation

Pypi package

Github page

Documentation

Categories: Informatika

Announcing the release of E-Maj 2.2.0

2017, December 19 - 01:00

I am very glad to announce the 2.2.0 version of E-Maj.

E-Maj is a PostgreSQL extension which enables fine-grained write logging and time travel on subsets of the database.

This new version supports from 9.2 to v10 PostgreSQL versions. It is a new step in giving more flexibility in tables groups management. In particular, it allows to remove tables or sequences from groups without being obliged to stop/restart the logging mecanism (and loose the capability to 'rollback' to a previous point in time).

Both web clients, Emaj_web and the phpPgAdmin plugin, have been enhanced to take benefit from this feature.

The full documentation is available on line. The core extension is available at pgxn.org or github.org.

The phpPgAdmin plugin and the Emaj_web application are also available at github.org.

Have fun with E-Maj !

Categories: Informatika

Announcing the Release of repmgr 4.0.1

2017, December 13 - 01:00

Oxford, United Kingdom - December 13, 2017

2ndQuadrant announces the minor release of repmgr 4. repmgr is the most popular tool for PostgreSQL replication and failover management. It enhances and complements PostgreSQL's built-in replication capabilities, making it easy to set up and manage standby servers, check replication status, and perform administrative tasks such as switchover operations. The repmgrd daemon provides automatic failover capability to maximise database uptime and can easily be integrated with other tools such as PgBouncer for high application availability.

repmgr 4.0.1 is a bug fix release. For a list of all fixed bugs, please read the full release notes here. Because of the important bug fixes present in this release, we highly recommend upgrading to repmgr 4.0.1. Download and install instructions are available here.

repmgr is developed and maintained by 2ndQuadrant. It is fully supported by their respected 24/7 Production Support, providing the fastest and highest rated response service for PostgreSQL anywhere and is available worldwide. repmgr is distributed under GPL v3.

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and 5 continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. We have adopted the open source business model and are Platinum sponsors for the PostgreSQL project. Our focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Categories: Informatika

pgBackRest 1.26 Released

2017, December 13 - 01:00

December 13, 2017: Crunchy Data is proud to announce pgBackRest 1.26, Reliable PostgreSQL Backup & Restore.

Release 1.26

Since the release of 1.09 in October 2016, the pgBackRest team has added S3 support, repository encryption, page checksum validation, and made a number of other improvements. The major new features added since 1.09 are detailed below.

Links New Features Amazon S3

Repositories can be created in S3 buckets for virtually unlimited storage.

Repository Encryption

The repository can be encrypted on any supported storage using the industry-standard AES-256 cipher.

Page Checksum Validation

Page checksums are validated automatically when enabled on PostgreSQL >= 9.3.

Improved Asynchronous Archiving

Asynchronous archiving is now multi-threaded and no longer maintains a separate WAL queue. This results in significantly better performance with less I/O.

Stanza Management

Stanzas are managed using the stanza-create and stanza-upgrade commands.

Configure Multiple Backup Standbys

Up to seven standbys can be configured for backup from standby. The first active standby in the list will be used for the backup.

About

pgBackRest aims to be a simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads.

Instead of relying on traditional backup tools like tar and rsync, pgBackRest implements all backup features internally and uses a custom protocol for communicating with remote systems. Removing reliance on tar and rsync allows for better solutions to database-specific backup challenges. The custom remote protocol allows for more flexibility and limits the types of connections that are required to perform a backup which increases security.

Crunchy Data supports the ongoing and active development of pgBackRest as an entirely open source project, released under the BSD-compatible MIT license.

Categories: Informatika

PGConf APAC - Registrations now open & CFP Extended

2017, December 13 - 01:00

We are pleased to announce that PGConf APAC 2018 will be held in Singapore on 22 & 23 March, 2018. Registrations are now open. To register, please follow this link: http://2018.pgconfapac.org/tickets.

Like all Postgres Events, PGConf APAC will be a great opportunity for you to get introduced to leading PostgreSQL users, developers, and to learn about the latest PostgreSQL release features.

Call For Papers is Extended

Call for Papers has been extended! Some of the topics which can be used for submitting a talk are-

  1. Migration projects
  2. Performance troubleshooting and tuning
  3. noSQL and geo-spatial features of Postgres
  4. Unique use-case and customer stories
  5. Useful new features in PostgreSQL 10

For more examples you can refer to the papers which were presented at last year's event - 2016 and 2017.

Of course we are happy to accept paper proposals on any other interesting topics as well. You can submit your paper over here: http://2018.pgconfapac.org/cfp.

Registrations are Open

We have opened up registration and ticket sale. Early bird registration closes on 7th Jan 2018. You can get tickets on http://2018.pgconfapac.org/tickets

Why Singapore?

Singapore is a global city and is very well connected via flights with major hubs across the globe. It has a unique cultural blend and population from different ethnicities and religions. The coexistence and sound infrastructure has provided the foundation for rapid growth of the country and its positioning as a trade, technological and financial hub.

These are the reasons why various PostgreSQL User Groups from Asia have come together to organize one of the largest PostgreSQL shows in Asia Pacific – PGConf APAC 2018, the first large-scale PostgreSQL conference for the Asia Pacific region.

Sponsors

PGConf APAC 2018 is built on the success of pgDay Asia 2017 and pgDay Asia 2016. These events would not have been possible without the generous sponsorships from various enterprises involved with or using PostgreSQL.

We would like to acknowledge our sponsors for this event:

  • Platinum Sponsor: Fujitsu
  • Gold Sponsors: 2ndQuadrant, EDB Postgres
  • Co-Hosts: Ashnik

If you would like to sponsor the event, you can find details on our website in Sponsors section.

In case of any questions, please write to: pgconfapac[at]googlegroups[dot]com

Categories: Informatika

Postgres Migration Tookit v3.1 has been released

2017, December 12 - 01:00

New version of Postgres Migration Tookit has been released. Major enhancements include:

  • new Access-to-PostgreSQL, Firebird-to-PostgreSQL and SQLite-to-PostgreSQL converters

  • support for Oracle v12.2 in Oracle-to-PostgreSQL converters

  • options to export into PostgreSQL script file and to specify PostgreSQL schema in FoxPro-to-PostgreSQL converter

Visit http://www.convert-in.com/pgskit.htm for details.

Categories: Informatika

Open letter : call to software vendors for an enterprise-grade support of PostgreSQL Database

2017, December 7 - 01:00

PARIS, december 6, 2017

We, at the PostgreSQL Cross-Enterprise Work Group, a non-profit organization advocating for the adoption and use of PostgreSQL, invite software vendors that don’t already do so to take steps to support PostgreSQL as a database management system (DBMS). The ambition of this initiative is to incite them to adapt quickly to the irresistible IT transformation in progress in public and private companies.

Founded in November 2016, PostgreSQL Cross-Enterprise Work Group is a dedicated task force inside the PostgreSQLFr non-profit association, gathering more than 20 participants from public organizations, CAC40 companies, start-ups, including Air France, Carrefour, CASDEN, CNES, EDF, GIE AGORA (MSA), ISOCEL (Leclerc), MAIF, Météo France, French Ministry of Education, PeopleDoc, SNCF, Société Générale and Tokheim Services Group.

Engaged in a common open-source transformation initiative, members of the Work Group have chosen to store all or part of their critical enterprise data in PostgreSQL databases.

The initiative aims at lowering the impact of vendor lock-in strategies in the enterprise database field. A long-standing near-monopolist position in this field has led to a situation in which customers are now facing important risks. They became so dependent on their traditional vendors that they could not move to another vendor without substantial switching costs. This created a context which favors the vendor at the expense of the customer.

With the rise of open source software solutions popularity, mainly due to their maturity, performance and stability, many firms looking for an alternative to proprietary DBMS did migrate or are considering the migration to the open source database PostgreSQL.

PostgreSQL offers qualities of robustness, performance, reliability and respect for open standards. It is a liberal open source license that allows companies to use it without restriction, without fear of audits, and lets the freedom to contribute to its development and ecosystem.

Members of the Work Group agreed to provide mutual assistance, share knowledge, contribute to the project and promote it to increase its public adoption, while strictly respecting procurement processes.

Increased cooperation with third party software vendors

As part of this initiative, and in order to answer the wide variety of business needs of its current and future members, the Work Group now calls to the cooperation of Independent Software Vendors.

"As IT transformation progresses, PostgreSQL becomes a de facto standard in our infrastructures. Part of our business applications rely on third party software we use and that come with proprietary database solutions which require us to override our corporate strategies and policies. To ensure we will continue to use software that do not support PostgreSQL yet, software providers are now urged to take the first steps leading to an adequate certification of PostgreSQL." explains Simon CLAVIER, Vice President of PostgreSQLfr association and spokesperson of the Work Group.

"This compliance is already required in our choice criteria for solutions and will be even more in a near future. In return, Software Vendors that certify their solution on PostgreSQL can count on a reliable support of PostgreSQL developers and users community, community in which they will be very welcomed."

Vendors that already support PostgreSQL are invited to come forward and to be added in our reference software list. Those that don't and are considering to become compliant are warmly invited to contact the Work Group on the following email address, indicating the expected date of support and sharing a reference URL : entreprises.contact@postgresql.fr

More about the PostgreSQL Cross-Enterprise Work Group : https://www.postgresql.fr/entreprises/english

Counting on your participation,

Freely,

The PostgreSQL Cross-Enterprise Work Group

NOTE : This page is a translation of the original page in French.

Categories: Informatika

Announcing the Release of OmniDB 2.4

2017, December 7 - 01:00

Oxford, United Kingdom — December 7, 2017

2ndQuadrant announces the release of OmniDB 2.4 This release includes a new real-time monitoring feature for the dashboard. The monitoring feature included in this release, is an interface present both in omnidb-app and omnidb-server. It allows the user to monitor in real-time, the situation of the database with multiple charts and grids for the major part of aspects that need to be monitored: backends, bloat, sizes, among others.

OmniDB is a browser-based database management tool. It is designed to be a powerful, yet lightweight, user-friendly and fast-performing interface for PostgreSQL databases. OmniDB is fully backed by 2ndQuadrant’s world renowned 24/7 Production Support.

The new features in this release are listed below:

  • Custom Monitoring Dashboard: User defined monitoring dashboard with charts and grids, allowing the user to create custom monitoring in a python sandbox.
  • Persistent user data: Configuration files and logs now persist through upgrades of new releases.
  • Bug fixes

For a complete list of changes, including detailed bug fixes, read the OmniDB change tracker here.

OmniDB 2.4 download and installation instructions are available here.

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and 5 continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. We have adopted the open source business model and are Platinum sponsors for the PostgreSQL project. Our focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Categories: Informatika

PostgreSQL PHP Generator Lite Released

2017, December 6 - 01:00

SQL Maestro Group announces the release of PostgreSQL PHP Generator Lite, a free yet powerful GUI frontend for Windows that allows you to generate feature-rich web applications for your PostgreSQL database without programming experience.

The new software is immediately available at
http://www.sqlmaestro.com/products/postgresql/phpgenerator/download/.

Top 10 features of the new product:
  1. Reliable and proven basis. PHP Generator Lite is based on exactly the same web engine as his "big brother" PHP Generator Professional, a world-class tool for creating data-driven web applications without writing a single line of code.
  2. No usage limitations. PHP Generator Lite allows you to create unlimited number of websites for unlimited number of users. Generated websites can be used for business or personal purposes.
  3. Customization for your needs. Generated pages can be customized with a lot of GUI settings as well as with user-defined styles and JavaScript. 18 color schemes are included.
  4. Responsive and adaptive. PHP Generator Lite allows you to build websites that look good on any device from a mobile phone to an extra-large desktop.
  5. Data filtering and sorting tools. Your end users will be glad to find records they are looking for or sort their data in a couple of clicks.
  6. Wide spectrum of controls. A bunch of available data grid column types and editors in data input forms will help you to create professionally looking websites with minimal efforts.
  7. Security settings. All you need to protect your data against unauthorized viewing or changing is to turn on just a single option and grant permissions to the users.
  8. Various data sources. Generated pages can be based on tables, views, and SELECT queries.
  9. Website navigation. Such features as sidebar menus, page groups, breadcrumbs, and automatic index page generation are at your disposal.
  10. And last but not least: the new tool is absolutely free.

Hope you'll enjoy our new tool. Full press release is available at the SQL Maestro Group website.

Categories: Informatika

Release: check_pgactivity 2.3

2017, December 4 - 01:00
check_pgactivity version 2.3 released

check_pgactivity is a PostgreSQL plugin for Nagios. This plugin is written with a focus on a rich perfdata set. Every new features of PostgreSQL can be easily monitored with check_pgactivity.

Changelog :

add complete support for PostgreSQL 10, including non-privileged monitoring features add some documentation to help new contributors add ability to use time units for thresholds in service backend_status fix a long-standing bug in service backends_status fix several issues

Here are some useful links: Github repo: https://github.com/OPMDG/check_pgactivity French release note: http://blog.dalibo.com/2017/12/04/Sortie_check_pgactivity_2.3.html

This tool is developed by Thomas Reiss, Jehan-Guillaume de Rorthais and Julien Rouhaud.

Categories: Informatika

DB Doc 5.0 released

2017, November 23 - 01:00

Yohz Software has just released DB Doc 5.0, the PostgreSQL schema documentation tool, and is available for immediate download.

Changes in this version:
  • Added support for PostgreSQL 10.1 databases.
  • Fixed a bug related to the rendering of tables with many columns.
DB Doc benefits:
  • Document a PostgreSQL database in 4 simple steps
  • Create documentation in HTML, CHM, PDF, and MS Word formats
  • Eliminate tedious and time-consuming manual documentation tasks
  • Satisfy audit requirements by keeping complete and timely documentation
  • View inter-object and inter-database dependencies in your documents
  • Document layouts can be fully customizable to suit your requirements
  • Keep teams up to date by distributing timely and accurate documentation
  • Runs on Windows XP to Windows 10
  • Runs on Linux using Wine, so you can use DB Doc on your favorite Linux distribution
  • Supports PostgreSQL 8.3 to 10.1, without the need for any additional database drivers.

For more details about DB Doc, please visit the product page here.

Categories: Informatika

Citus 7.1 Released: Distributed Transaction Support

2017, November 22 - 01:00

Citus Data announces the availability of Citus 7.1. Built to scale out, Citus is an extension to Postgres that is available as open source, enterprise software, and a fully-managed database service on AWS.

Whether you have a multi-tenant application that needs scale, or you need to deliver real-time analytics to your customers, with Citus, you can seamlessly scale your PostgreSQL clusters.

Citus 7.1 adds full SQL support for distributed transactions. This release also expands SQL coverage for parallel subqueries, window functions, and distinct clauses. You can find more information in Citus release notes.

Citus 7.1 is compatible with PostgreSQL 9.6 and 10. You can try Citus 7.1 by following the download instructions or one-click deploy through the Citus Cloud console.

Categories: Informatika

Announcing the Release of repmgr 4.0

2017, November 21 - 01:00

Oxford, United Kingdom - November 21, 2017

2ndQuadrant is proud to announce the release of repmgr 4.0. repmgr has been the most popular tool for PostgreSQL replication and failover management since 2010. It enhances and complements PostgreSQL's built-in replication capabilities, making it easy to set up and manage standby servers, check replication status, and perform administrative tasks such as switchover operations.

The repmgrd daemon provides automatic failover capability to maximise database uptime and can easily be integrated with other tools such as PgBouncer for high application availability.

This new release is a complete rewrite of the existing repmgr codebase, implementing repmgr as a fully-fledged PostgreSQL extension and providing full support for the recently released PostgreSQL 10. This release includes other important enhancements, some of which are listed below:

  • Improved switchover functionality
  • Redesigned failover mechanism
  • --dry-run mode for many operations
  • New “repmgr node rejoin” command to reintegrate former primaries
  • Replication monitoring checks
  • Improved logging output
  • Automatic configuration file detection in RPM and DEB packages
  • Easier upgrade process for future repmgr versions

Read the full release notes for repmgr 4.0 here

repmgr is developed and maintained by 2ndQuadrant. It is fully supported by their respected 24/7 Production Support, providing the fastest and highest rated response service for PostgreSQL anywhere and is available worldwide. repmgr is distributed under GPL v3.

Repmgr 4 download and installation instructions are available here

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and 5 continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. We have adopted the open source business model and are Platinum sponsors for the PostgreSQL project. Our focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Categories: Informatika

Pages

Theme by me