PDU
DocsFull Usage Guide

Full Usage Guide

Master all PDU features and become a data recovery expert

Command Reference

Complete reference for all PDU commands including data export, recovery operations, and dropped table scanning.

Parameter Reference

Configuration file settings and runtime parameters for WAL scanning, recovery modes, and disk scanning.

System Requirements

Supported Platforms

  • EL 7 / 8 / 9
  • ARM64 Linux
  • x86_64 Linux

PostgreSQL Versions

  • PostgreSQL 10 - 18
  • Version-specific executables
  • pdu10, pdu11, ... pdu18

Quick Start

1

Extract PDU Package

Unzip the PDU package to your preferred directory.

unzip PDU3.0_for_Postgresql10-18.zip
2

Configure pdu.ini

Set PGDATA and ARCHIVE_DEST paths in the configuration file.

vim pdu.ini
3

Select Version and Launch

Choose the executable matching your PostgreSQL version.

./pdu14 # For PostgreSQL 14
4

Initialize Database Metadata

Run the bootstrap command to load database structure.

b;

Exported Data Structure

pdu/
├── database_name/
│   ├── schema_name/
│   │   ├── table1.csv0         # Table data CSV files
│   │   ├── table2.csv0
│   │   └── ...
│   ├── DDL/
│   │   └── schema_name_ddl.sql # CREATE TABLE statements
│   └── COPY/
│       └── schema_name_copy.sql # COPY import statements
└── restore/
    ├── datafile/               # Manually added data files
    ├── dropscan/               # Dropped table recovery results
    ├── meta/                   # Metadata files
    └── tab.config              # dropscan table config
Instant RecoveryCommand Reference