by Abhishek Deb | Jun 26, 2023 | Insight for DBAs, PostgreSQL
We have faced different levels of corruption related to databases in PostgreSQL. Our colleague has written multiple blogs on the subject; please refer to the below links for more: The Ultimate Guide to Database Corruption: Part 1 – An Overview The Ultimate Guide to...
by Robert Bernier | Jun 15, 2023 | Insight for DBAs, Insight for Developers, PostgreSQL
This post was originally published in 2020 and has been updated in 2023. Mastering Geographical Information Systems, better known simply as GIS, can be considered in some ways as a rite of passage. The complexities and challenges involved in learning, which are...
by Peter Zaitsev | Jun 14, 2023 | Insight for DBAs, PostgreSQL
A few days ago, Heikki Linnakangas posted a message in the PostgreSQL mailing list titled “Let’s make PostgreSQL multi-threaded.” This topic got quite a discussion on Hacker News too. The poll I’ve done on Twitter shows there is great interest in this topic and...
by Pete Scott | Jun 12, 2023 | Insight for DBAs, MySQL, Percona Software, PostgreSQL
When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied....
by Agustín | Jun 9, 2023 | Insight for DBAs, Monitoring, PostgreSQL
Percona Monitoring and Management (PMM) boasts many functionalities that support its extension, be it by using Custom Queries, Custom Scripts, or by collecting data from already available External Exporters. In this short blog post, we will see how to quickly (and...
by Sonia Valeja | Jun 7, 2023 | Insight for DBAs, PostgreSQL
PostgreSQL provides a powerful mechanism for implementing event-driven actions using triggers. Triggers on Data Definition Language (DDL) events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database...
by Robert Bernier | Jun 5, 2023 | Insight for DBAs, PostgreSQL
From time to time, situations occur where unusual circumstances dictate out-of-the-box thinking. For example, suppose you have a system where you’ve installed multiple data clusters onto a single host. What you end up with is a host breaking up and sharing valuable...
by Bhargav Kamineni | May 8, 2023 | Insight for DBAs, PostgreSQL
In simpler terms, logical replication in PostgreSQL is a way to copy data from one database to another in a more flexible and customizable manner compared to physical replication. Instead of copying the entire database, logical replication focuses on replicating...
by Sergey Pronin | Apr 20, 2023 | Cloud, Percona Software, PostgreSQL, Security
Data-at-rest encryption is essential for compliance with regulations that require the protection of sensitive data. Encryption can help organizations comply with regulations and avoid legal consequences and fines. It is also critical for securing sensitive data and...
by Naveed Shaikh | Apr 13, 2023 | Insight for DBAs, PostgreSQL
This blog was originally published in April 2023 and was updated in April 2024. PostgreSQL is a popular open source relational database management system that is widely used for storing and managing data. One of the common issues that can be encountered in PostgreSQL...
by Agustín | Apr 6, 2023 | Insight for DBAs, Monitoring, MySQL, Percona Software, PostgreSQL
In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to get not only metrics and queries from our database servers but also text-based information like logs. Loki is a log aggregation tool developed by...
by Abdul Sayeed | Apr 3, 2023 | Insight for DBAs, Percona Services, PostgreSQL
We all know that PostgreSQL 10 has reached end of support, so if you’re still running it, the time to upgrade is now. Staying on an unsupported version means no more security fixes or bug patches, which puts your applications and data at risk. There are a few...
by Pete Scott | Mar 30, 2023 | Insight for DBAs
The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. This comprehensive...
by Sonia Valeja | Mar 28, 2023 | Insight for DBAs, PostgreSQL
Our previous blogs discussed configuring and setting up backups using the pgBackRest solution. To briefly explain pgBackRest, it is an open source backup tool that takes FULL Backup, Incremental Backup, and Differential Backup for PostgreSQL databases. Repository...
by Vadim Tkachenko | Mar 21, 2023 | Insight for DBAs, PostgreSQL
Announcement I will be speaking at Percona Live 2023 about serverless PostgreSQL. Join us at this event if you are interested! Introduction Recently, Percona introduced Percona Builds for Neon (Introducing Percona Builds for Serverless PostgreSQL), which makes it easy...
by Vadim Tkachenko | Mar 13, 2023 | Insight for DBAs, PostgreSQL
Announcement I will be speaking at Percona Live 2023 about serverless PostgreSQL. Join us at this event if you are interested! Introduction Recently, Percona introduced Percona Builds for Neon (Introducing Percona Builds for Serverless PostgreSQL), which makes it easy...
by Naveed Shaikh | Feb 20, 2023 | Cloud, Insight for DBAs, PostgreSQL
Recently, one of our customers approached us with a unique challenge: they needed to migrate their entire PostgreSQL cluster from DigitalOcean’s Database as a Service (DBaaS) to a DigitalOcean Droplet. The reason for their migration from DBaaS to Droplets was to...
by Jan Wieremjewicz | Feb 14, 2023 | Insight for DBAs, PostgreSQL
The final PostgreSQL 10 release was published on November 10, 2022, according to the PostgreSQL versioning policy page. Please remember that the final PostgreSQL 11 release is planned for November 9, 2023. Following Percona’s Release Lifecycle policies, we follow and...
by David Stokes | Feb 13, 2023 | Insight for DBAs, PostgreSQL
Yes, MySQL DBAs can learn PostgreSQL! This series is for those who know MySQL and want to expand their knowledge, see how another database works, or are looking to expand their career horizons. In this episode we will look at transactions. Yes, MySQL with InnoDB does...
