On Wed, Apr 6, 2011 at 9:48 AM, aaronenabs <aaronenabs(at)btconnect(dot)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