pg_orphaned

pig build pkg pg_orphaned;		# build rpm/deb

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

pig install pg_orphaned;		# install via package name, for the active PG version

pig install pg_orphaned -v 18;   # install for PG 18
pig install pg_orphaned -v 17;   # install for PG 17
pig install pg_orphaned -v 16;   # install for PG 16
pig install pg_orphaned -v 15;   # install for PG 15
pig install pg_orphaned -v 14;   # install for PG 14

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();