| From: | Mark Steben <mark(dot)steben(at)drivedominion(dot)com> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | pg_repack issues |
| Date: | 2014-11-11 22:07:20 |
| Message-ID: | CADyzmywDKBOgMuG4-GMsMUxApA5iWfa84Bkq603ifGeJxAmJFA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Good afternoon,
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 <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567
www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com <http://www.autorevenue.com/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2014-11-12 02:26:23 | Re: pg_repack issues |
| Previous Message | christian.echerer | 2014-11-10 13:48:40 | Missing timeline history file after execution of pg_upgrade |