~/talk

How to create an hacking toolkit thanks to the pageinspect ...

Talkat PGConf NYC 2022 · 2022-09-22..09-23· [security, databases]
links:none on file
slides:none on file

Shell scripts (no C) use pageinspect plus dd and od to read page checksum and extract how many tuples are on a page, and pull tuple header fields like xmin, xmax, infomask and infomask2 and full HeapTupleHeaderData plus user data. Scripts reproduce pageinspect functions (page_header, heap_page_items, bt_metap, bt_page_items, bt_page_stats), read xact status and multixid members directly from filesystem files, link user tuples to toast pages via toast index data, and search tuples by attribute values for disk vs memory comparison or crashed-engine forensics.

AI-written summary · about

  1. 0:00Introduction
  2. 4:44Starting with psql data
  3. 14:24Identifying the problem
  4. 23:54Working with transactions
  5. 31:49Demo of the toolkit
  6. 39:30Conclusion and Q&A
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.