Categories
Products
Technologies
Top Rated docs

March 10, 2025

PostgreSQL Bi-Directional Logical Replication — A Deep Dive

PostgreSQL offers a robust, open-source, reliable, and flexible database system allowing businesses to scale their data operations effectively. PostgreSQL continues to improve to meet the needs of modern applications. One of its recent improvements is...

March 6, 2025

Clustercontrol adds PostgreSQL Bi-Directional Logical Replication and Valkey Sentinel v8.0 in latest release

Clustercontrol v2.3.1 is here, packed with powerful new enhancements to simplify database management and ensure high availability across databases. This release introduces PostgreSQL Bi-Directional Logical Replication and expands support for Valkey Sentinel v8.0, an open-source...

March 20, 2024

Vector Similarity Search with PostgreSQL’s pgvector – A Deep Dive

As the AI revolution surges forward, promising significant innovations, it also introduced new types of vector databases. A vector database stores data as high-dimensional vectors called embeddings, which are mathematical representations of features or attributes...

February 1, 2021

Tips for Monitoring PostgreSQL for Moodle

Moodle is a Learning Management System (LMS) designed to provide educators, administrators, and learners with a single robust, secure, and integrated system to create personalized learning environments. It supports different database technologies (e.g. MariaDB, MySQL,...

January 28, 2021

Automatic Failover of the Moodle PostgreSQL Database

One of the key aspects of high availability is the ability to quickly react to failures. It is not uncommon to manually manage databases, and have monitoring software keep an eye on database health. In...

January 18, 2021

Challenges of Scaling the Moodle PostgreSQL Database

Moodle is the most popular learning management system (LMS), and it allows educators to create their own website with courses or content that extend learning. These kinds of platforms are getting more and more important to...

January 15, 2021

How to Audit a PostgreSQL Database

Auditing is a good way to keep your data as safe as possible, and to know what is happening in your databases. It is also required for many security regulations or standards, like PCI -...

November 23, 2020

How to Deploy a Highly Available Canvas LMS with a PostgreSQL Database Cluster

In these pandemic times, Learning Management System (LMS) platforms are getting more and more important to allow you to continue learning remotely when the traditional education system just isn’t available anymore. Having an LMS platform...

November 16, 2020

Using the pt-pg-summary Percona Toolkit for PostgreSQL

The Percona Toolkit is a powerful, free, and open-source product developed by Percona. It is a collection of command-line tools that allow you to perform different MySQL, MongoDB, PostgreSQL, and system tasks that, in general,...

November 9, 2020

How to Deploy Percona Distribution for PostgreSQL for High Availability

High Availability is a requirement for many systems, no matter what technology you are using. This is especially important for databases, as they store data that applications rely upon. Depending on the requirements, there are...

November 3, 2020

Monitoring Percona Distribution for PostgreSQL – Key Metrics

Monitoring is the base to know if your systems are working properly, and it allows you to fix or prevent any issue before affecting your business. Even in a robust technology like PostgreSQL, monitoring is...

October 27, 2020

Top Open Source Tools for PostgreSQL Migrations

Database migration is the process of migrating data from one or more source databases to one or more target databases by using a service or tool. There are different types of migrations. You can migrate...

Subscribe below to be notified of fresh posts