pg_repack issues

Поиск
Список
Период
Сортировка
От Mark Steben
Тема pg_repack issues
Дата
Msg-id CADyzmywDKBOgMuG4-GMsMUxApA5iWfa84Bkq603ifGeJxAmJFA@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_repack issues
Список 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 | Autobase 
  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





В списке pgsql-admin по дате отправления: