Unique Advantages

PDU stands apart from other PostgreSQL recovery tools through its unique combination of simplicity, capability, and safety. Here's what makes PDU different.

Simplicity: Two Files, Complete Solution

Minimal Footprint

PDU consists of only two files:

pdu{10-18}

The executable file for your PostgreSQL version

pdu.ini

Simple configuration file with just 2 key settings

Compare to Traditional Approaches

• No complex dependencies to install
• No lengthy setup procedures
• No compilation required
• No database server installation needed
• Works immediately after extraction

Unified Interface: One Tool for All Scenarios

Instead of juggling multiple tools with different interfaces, PDU provides a single, consistent interface for all recovery scenarios:

Scenario	Traditional Tools	PDU
Corrupted database	pg_filedump + manual parsing	b; → unload
Deleted records	pg_waldump + pg_dirtyread	scan → restore del
Updated records	pg_waldump + custom scripts	scan → restore upd
Dropped tables	No solution	dropscan

PostgreSQL-Native Experience

PDU feels like a natural extension of psql. If you know PostgreSQL, you already know how to use PDU:

Familiar Commands

\lList databases

\dnList schemas

\dtList tables

\d+ tableDescribe table

Intuitive Navigation

use dbname;Switch database

set schema;Switch schema

\qExit

Non-Invasive: Read-Only Recovery

PDU Approach

Only reads source data files
Never modifies original files
Outputs to separate directory
Safe to retry multiple times

Traditional Tools Risk

pg_resetwal may cause data loss
Some tools modify source files
Errors may worsen corruption
One chance only approach

The Only Solution for DROP TABLE

The ONLY Revealed Feasible Method

When a table is dropped without a backup, traditional PostgreSQL tools offer no solution. The data files are immediately unlinked, and the metadata is removed from system catalogs.

PDU's dropscan command is currently the only publicly available method to recover data from dropped tables by scanning disk fragments for recoverable data pages.

Data Type Support

Professional Trial, Professional, and Enterprise editions can recover the common PostgreSQL data types used by business applications, as well as enum, domain, range, text-search, and pgvector data.

Numeric Types

smallintintegerbigintnumericrealdouble precisionmoney

Text and Binary

char(n)varchar(n)textnamebytea

Date and Time

datetimetimetztimestamptimestamptzinterval

JSON, XML, and General Types

jsonjsonbjsonpathxmlbooleanuuid

Network and Bit Strings

inetcidrmacaddrbitvarbit

Other Common Types

enumdomaintsvectorrangemultirangevector

Enterprise Edition: Adds the array types listed in Supported Data Types and PostGIS geometry, geography, and raster columns. Community Edition differences, PostgreSQL version requirements, and currently unsupported types are listed there as well. View the full list

Version Compatibility

PDU provides dedicated executables for each PostgreSQL major version, ensuring accurate data parsing across different internal formats:

PostgreSQL 10PostgreSQL 11PostgreSQL 12PostgreSQL 13PostgreSQL 14PostgreSQL 15PostgreSQL 16PostgreSQL 17PostgreSQL 18

EL 7/8/9

Ubuntu Linux

Debian Linux

Linux x86_64

Linux ARM64

Summary: Why Choose PDU

📦

Simple

Two files, zero dependencies

🔧

Unified

One tool for all scenarios

🐘

Familiar

PostgreSQL-native experience

🛡️

Safe

Read-only, non-invasive

🎯

Unique

Only DROP TABLE solution

✅

Compatible

PostgreSQL 10-18 support