Publications by tag PostgreSQL

Learn from a real-world journey of upgrading a heavily loaded PostgreSQL cluster from v13 to v16 while keeping it highly available. This story comes with detailed listings and pitfalls encountered on the way to success.

Downsizing a PostgreSQL cluster’s primary server can manifest into an exciting engineering adventure. Here’s our recent experience performing such a routine task and the lessons we learned from it.

Using PgBouncer for your PostgreSQL databases in production? Monitoring this connection pooler is essential to ensure the applications’ reliability and performance. Learn how to make it just right with real-life examples for Odarix.

Atlas is an Open Source tool that simplifies using the Infrastructure as Code approach for your database schemas. In this article, we will give it a try for MySQL and PostgreSQL databases running in containers.

This tutorial helps you in setting up metrics collection based on the log file (of PostgreSQL in this specific case) and alerts based on these metrics.

CloudNativePG is a new Kubernetes operator for PostgreSQL DBMS, released early this year. Let's examine its main features and compare them with other existing solutions.

Migrating a Patroni-based PostgreSQL (v11.13) cluster brought us some unforeseen issues. Dive into this in-depth tutorial to avoid them when you have a similar challenge!

Debezium is a distributed platform for change data capture built on top of Apache Kafka. Here is a short introduction to it and our experience of connecting it with two DBMSs.

Our new exciting SRE/Ops stories include complicated Linux server migration (bare-metal to VM), large PostgreSQL replica recovery, small case with ClickHouse Kubernetes operator, and abnormal result of CockroachDB upgrade.

Fascinating lessons learned using the Kubernetes operator for PostgreSQL of our choice — Postgres Operator by Zalando. Problems and solutions, the story of migrating production.

Evaluating five popular Kubernetes operators for PostgreSQL: Stolon, Crunchy Data, Zalando, KubeDB, and StackGres — and comparing them in a features matrix.

Our stories include a poorly prepared Kafka in Docker, an unexpected network issue for ZooKeeper & ClickHouse, a faulty hardware in the data center, and the PgSQL database optimization.