Booster's Blog

A blog hosted on GitHub Pages

Posts WIKI About me Photos Repositories
2025-02-10

How to Update RDS PostgreSQL with Minimal Downtime

Disclaimer

When working with Amazon RDS for PostgreSQL, minimizing downtime during updates is essential to maintain high availability. One of the most effective ways to achieve this is by using the Blue/Green deployment technique.
Although AWS introduced this feature for PostgreSQL in December 2023, it still has some limitations that may prevent you from fully leveraging it:

  • RDS Proxy is not currently supported.
  • Instances with subscriptions can’t use it.
  • Your database must have the last minor version
  • You don’t get a built-in rollback option after cutover, so reverting to the old version without losing data isn’t possible.
Read more...
2024-12-08

Automated Password Rotation in RDS

Introduction

This article covers the setup of Automated password rotation for a PostgreSQL user using AWS Secrets Manager and Lambda. This process enhances security by ensuring that credentials are regularly updated without manual intervention.
By the end of this article, a fully functional system for automatically rotating PostgreSQL user passwords will be in place.

Read more...
2023-08-18

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.

Read more...