On Wed, Apr 6, 2011 at 9:48 AM, aaronenabs <aaronen...@btconnect.com> wrote: > True, i have looked at pg_dumpfile and worked around that, Seems to be a very > important tool for forensic investigations. But looking for any other aspect > of the DBMS that can be helpful.
pageinspect is useful. Also there are hidden xmin and xmax columns in every tuple which can be helpful also. Unfortunately there's no way to shut off visibility checks and see the tuples that MVCC is filtering out. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
