{"repo":"Chocapikk/pgread","free":true,"listed":false,"github":"https://github.com/Chocapikk/pgread","clone":"git clone https://github.com/Chocapikk/pgread.git","description":"Read PostgreSQL data files without credentials - forensics, data recovery, and security research tool","language":"Go","stars":48,"topics":["data-recovery","database","dfir","forensics","golang","pentest","postgresql","red-team","security"],"license":"WTFPL","category":"databases-storage","readme_excerpt":"pgread Dump PostgreSQL data without credentials - if you can read the files, you can dump the database. Blog post: Dumping PostgreSQL Without Credentials: Heap File Parsing for Offensive Security The Technique PostgreSQL uses fixed OIDs for system catalogs: OID Catalog Path ----- --------- ------ 1262 pg database global/1262 1259 pg class base/ /1259 1249 pg attribute base/ /1249 Leak these 3 files → discover entire schema → dump any table. Install CLI Password Extraction Secret Detection (Powered by Trufflehog) Uses trufflehog's 700+ detectors: Detects: Stripe, AWS, GitHub, GitLab, Slack, SendGrid, Doppler, DigitalOcean, Heroku, and 700+ more. WAL Analysis pg control Parsing Checksum Verification Detects page corruption before PostgreSQL does! Index Parsing Supports: BTree , GIN , GiST , Hash , SP-GiST Dropped Columns Recovery Recover data from columns that were ALTER TABLE DROP COLUMN ! Sequence Parsing pg filenode.map Parsing Maps system catalog OIDs to their physical filenodes. Block Range Selection Read specific blocks: 0:10 (blocks 0-10), 5: (from 5), :20 (up to 20), 5 (block 5 only). Binary Block Dump Raw hex dump like xxd or hexdump -C . Useful for low-level forensics. Multi-Segment Files PostgreSQL splits large tables into 1GB segments. pgread handles this: TOAST Verbose Table Output (psql-style) SQL/CSV Export Library Auto-Detection Low-Level API Supported Types Numeric: bool int2 int4 int8 float4 float8 numeric money Text: text varchar char bpchar name bytea Date/T","default_branch":null,"files":null,"tree":[],"storefront":"/r/Chocapikk","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Chocapikk/pgread/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}