postgres pg_filedump - ghdrako/doc_snipets GitHub Wiki

• https://www.highgo.ca/2021/07/14/first-contact-with-the-pg_filedump/

pg_filedump is a utility to format PostgreSQL heap/index/control files into a human-readable form.

Create test data:

CREATE TABLE test(id int, name text);
INSERT INTO test values(001, 'Aerith'), (002, 'Cloud'), (003, 'Tifa');

View file path:

SELECT pg_relation_filepath(‘test’);
pg_relation_filepath
———————-
base/14236/164333

Using pg_filedump viewing files:

% pg_filedump $PGDATA/base/14236/164333

We can also use it to repair data, as mentioned in this slides — https://pgday.ru/presentation/146/59649714ee40a.pdf