Master PostgreSQL Backup & Recovery: Logical, Physical, PITR, Automation, and Best Practices

This comprehensive guide explains PostgreSQL backup and recovery techniques—including logical and physical backups, point‑in‑time recovery, automation scripts, security measures, and production‑grade best practices—to ensure data availability, integrity, and compliance.

Database AdministrationPITRPostgreSQL

0 likes · 9 min read

Master PostgreSQL Backup & Recovery: Logical, Physical, PITR, Automation, and Best Practices

Qingyun Technology Community

Nov 9, 2021 · Databases

How to Configure PostgreSQL Point-In-Time Recovery (PITR) for Instant Data Restoration

This guide walks through setting up PostgreSQL's Point‑In‑Time Recovery (PITR) by enabling WAL archiving, performing a base backup, simulating data loss, and restoring the database to a specific timestamp, complete with command‑line examples and verification steps.

DatabasePITRPostgreSQL

0 likes · 9 min read

How to Configure PostgreSQL Point-In-Time Recovery (PITR) for Instant Data Restoration

Aikesheng Open Source Community

Jul 19, 2021 · Databases

MongoDB Cluster Point-in-Time Recovery (PITR) Procedure Using Shard and Config Server Restoration

This article demonstrates a step‑by‑step point‑in‑time recovery of a MongoDB sharded cluster by restoring shard instances, replaying oplog entries to a specific timestamp, updating metadata, and finally rebuilding the config server and mongos to achieve a consistent snapshot with max(id)=15.

MongoDBOplogPITR

0 likes · 13 min read

MongoDB Cluster Point-in-Time Recovery (PITR) Procedure Using Shard and Config Server Restoration