I have recently be using pg_repack and for one of my production databases have the following issue:
INFO: repacking table "mailer_admin" ERROR: query failed: ERROR: value "3048471620" is out of range for type integer DETAIL: query was: SELECT pg_try_advisory_lock($1, $2)
This happens because the oid values of the tables is this database are all over 2 GB. Can I get some insight to make pg_repack work in this situation?
If I am double posting I apologize. The pg_repack doc instructs to send questions to the reorg-general list. I suspect this is an obsolete list as I haven't received a response to my subscription request in over 2 weeks.
thanks for your help,
--
Mark Steben Database Administrator @utoRevenue|Autobase CRM division of Dominion Dealer Solutions 95D Ashley Ave. West Springfield, MA 01089 t: 413.327-3045 f: 413.383-9567