How to Update RDS PostgreSQL with Minimal Downtime
When working with RDS PostgreSQL, minimizing downtime during updates is crucial for maintaining availability. This guide describes a manual process to update your database with minimal downtime. However, the process involves a bunch of commands, and if you do everything manually, you’re likely to make mistakes in production. To avoid this, consider automating these steps using Python or other scripting tools to streamline the process and reduce the risk of errors.
Adding an Existing Table as a Large Partition in PostgreSQL (part 1)
There are many strategies for migrating a regular table to a partitioned table. Today, I’ll implement one of them. The main approach involves the following steps:
Freeing Up Disk Space in PostgreSQL by Deleting WAL Files
It’s crucial to avoid running out of disk space in PGDATA, but if it does happen, we have several options to manage the situation.
How to BlueGreen Postgres with Patroni
We have a configured cluster with Patroni, >=2 nodes. The task is to preserve the state of the database before deployment and, in case of failure, roll back to it.
Intentional Data Corruption for Backup Testing
Sometimes, when testing backup utilities like WAL-G, Pgbackrest, and others, it’s necessary to intentionally corrupt data. This is because the features advertised by these tools don’t always correctly verify checksum corruption, for example, as in the case of WAL-G, where the tool fails to detect bad checksums when using the -v flag.