We currently use the 'usesysid' column from pg_shadow (which is really
pg_authid.oid I assume) for a trigger-based auditing mechanism.
We are about to do a dump from an 8.2 database into 8.4 and would like to
preserve the usesysid/oid when restoring.
No matter what options I throw ad pg_dumpall, it gives me 'create role'
commands...and obviously no preservation of the oids.
Any suggestions on how I can manage this?