Usually, the PostgreSQL Community releases minor patches on the Thursday of the second week of the second month of each quarter. This can vary depending on the nature of the fixes. For example, if the fixes include critical fixes as a postgres community response to security vulnerabilities or bugs that might affect data integrity. […]Read more
When you need to upgrade your PostgreSQL databases, there are a number of options available to you. In this post we’ll take a look at how you can upgrade PostgreSQL versions using pg_upgrade, a built-in tool that allows in-place upgrade of your software. Using pg_upgrade allows you, potentially, to minimize your downtime, an essential […]Read more
Native streaming replication in PostgreSQL works only between servers running the same major version. We discussed about logical replication in our previous blog post. In that post, we saw how logical replication could help us set up migration between two different PostgreSQL versions. However, logical replication works only for the currently supported versions of […]Read more
When you need to upgrade PostgreSQL, there are a variety of approaches that you can use. To avoid application downtime, then not all of the options to upgrade postgres are suitable. When avoiding downtime is essential, then you might consider using replication as a means of upgrade, and depending on your scenario, you can […]Read more
In this blog post, we will explore
pg_restore, one of the most commonly used options for performing a PostgreSQL upgrade. It is important to understand the scenarios under which
pg_restore utilities will be helpful.
This post is the second of our Upgrading or Migrating Your Legacy PostgreSQL to Newer PostgreSQL Versions […]
Percona announces the release of Percona Monitoring and Management 1.5.1. This release contains fixes for bugs found after Percona Monitoring and Management 1.5.0 was released.
PMM-1771: When upgrading PMM to 1.5.0 using Docker commands, PMM System Summary, PMM Add Instance, PMM Query Analytics dashboards were not available.
PMM-1761: The PMM Query Analytics dashboard did not display the list of hosts correctly.
PMM-1769: It was possible to add an Amazon RDS instance providing invalid […]
Percona announces the release of Percona Monitoring and Management 1.5.0 on November 28, 2017.
This release focuses on the following features:
Enhanced support for MySQL on Amazon RDS and Amazon Aurora – Dedicated Amazon Aurora dashboard offers maximum visibility into key database characteristics, eliminating the need for additional monitoring nodes. We renamed Amazon RDS OS Metrics to Amazon […]Read more
Percona announces the release of Percona Monitoring and Management 1.4.1 on Thursday, November 2nd, 2017. This release contains fixes to bugs found after Percona Monitoring and Management 1.4.0 was released. It also introduces two important improvements. We replaced the btrfs file system with XFS in AMI and OVF images, and the Prometheus dashboard has been enhanced to offer more information.
For install and upgrade instructions, […]
Percona announces the release of Percona Monitoring and Management 1.4.0.
This release introduces the support of external Prometheus exporters so that you can create dashboards in the Metrics monitor even for the monitoring services other than those provided with PMM client packages. To attach an existing external Prometheus exporter, run pmm-admin add external:metrics NAME_OF_EXPORTER URL:PORT.
The list of attached […]
Percona announces the release of Percona Monitoring and Management 1.3.2. This release only contains bug fixes related to usability.
For install and upgrade instructions, see Deploying Percona Monitoring and Management.
PMM-1529: When the user selected “Today”, “This week”, “This month” or “This year” range in Metrics Monitor and clicked the Query Analytics button, the QAN page opened […]Read more