pg_orphaned

pig build pkg pg_orphaned         # build RPM / DEB packages

pig repo add pgsql -u          # Add repo and update cache

CREATE EXTENSION pg_orphaned;

-- List orphaned files (default: older than 1 day marked as "older")
SELECT * FROM pg_list_orphaned();

-- Custom age threshold
SELECT * FROM pg_list_orphaned('10 seconds');
SELECT * FROM pg_list_orphaned('1 minute');

-- Move files older than the threshold to orphaned_backup directory
SELECT pg_move_orphaned('1 minute');

SELECT * FROM pg_list_orphaned_moved();

SELECT pg_move_back_orphaned();

SELECT pg_remove_moved_orphaned();

-- 1. Check for orphaned files
SELECT * FROM pg_list_orphaned('1 minute');

-- 2. Move them to backup (only those older than threshold)
SELECT pg_move_orphaned('1 minute');

-- 3. Verify what was moved
SELECT * FROM pg_list_orphaned_moved();

-- 4. After confirming, remove the backup files
SELECT pg_remove_moved_orphaned();