Re: pg_dumpall 8.1.4 large objects error

Поиск
Список
Период
Сортировка
От Jeff Frost
Тема Re: pg_dumpall 8.1.4 large objects error
Дата
Msg-id Pine.LNX.4.64.0606070950040.27250@glacier.frostconsultingllc.com
обсуждение исходный текст
Ответ на Re: pg_dumpall 8.1.4 large objects error  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg_dumpall 8.1.4 large objects error
Список pgsql-admin
On Tue, 6 Jun 2006, Tom Lane wrote:

> Some cursory trawling in the REL7_3 sources says that this means that
> "SELECT DISTINCT loid FROM pg_largeobject" found a large object OID
> that then could not be found by an indexscan of pg_largeobject.  So
> I'd try a REINDEX of pg_largeobject to see if that fixes it.  See the
> REINDEX man page concerning hoops you have to jump through to reindex
> a system catalog --- IIRC, the hoops are much higher and narrower back
> in 7.3.

Thanks Tom.  BTW, you might be amused to see the uptime output prior to
shutting the machine down to add a PCI card:

  10:17am  up 1004 days, 7 min,  1 user,  load average: 0.00, 0.00, 0.00


--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

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

Предыдущее
От: "mcelroy, tim"
Дата:
Сообщение: Re: growth of a postgresql database
Следующее
От: "Aaron Bono"
Дата:
Сообщение: Re: Standalone Postgres