PG recovery — 3 Technical Articles

Aug 26, 2025 · Operations

Recovering a Ceph PG from Inactive and Incomplete States After a Power Outage

This article details a step‑by‑step recovery of a Ceph placement group that entered inactive and incomplete states after a data‑center power loss, explaining the meanings of these states, attempted repairs, use of ceph‑objectstore‑tool to manipulate PG replicas, and restoration of lost RBD image metadata.

CephPG recoveryRBD

0 likes · 15 min read

Recovering a Ceph PG from Inactive and Incomplete States After a Power Outage

Qingyun Technology Community

Dec 7, 2021 · Databases

How pg_recovery Retrieves Deleted Rows in PostgreSQL: Design & Code Walkthrough

This article explains the implementation principles, design ideas, and source‑code analysis of PostgreSQL's pg_recovery tool, detailing how it reads dead tuples, controls memory, and returns data through a custom function with configurable parameters.

Database RecoveryPG recoveryPostgreSQL

0 likes · 7 min read

How pg_recovery Retrieves Deleted Rows in PostgreSQL: Design & Code Walkthrough

Qingyun Technology Community

Dec 7, 2021 · Databases

Recover Lost PostgreSQL Data with pg_recovery: Step‑by‑Step Guide

This article introduces the open‑source pg_recovery tool for PostgreSQL, explains how to install it, and demonstrates recovering data lost through UPDATE, DELETE, ROLLBACK, and DROP COLUMN operations with practical command‑line examples.

Data RecoveryDatabase ToolsPG recovery

0 likes · 8 min read

Recover Lost PostgreSQL Data with pg_recovery: Step‑by‑Step Guide