Re: [ADMIN] postgres 8.2.6 core dump when initialising.

2008-04-15 Thread Tom Lane
Darren Reed <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> BTW, could you send me the contents of file 24579 in that database >> (dump it with pg_filedump, same as before)? According to your dump >> that's the reindexed version of pg_class_oid_index, and I'm curious >> to see whether it contains

Re: [ADMIN] postgres 8.2.6 core dump when initialising.

2008-04-14 Thread Tom Lane
Darren Reed <[EMAIL PROTECTED]> writes: > See if the attached helps. Well, here's the entry for the index it's trying to load: > Item 12 -- Length: 164 Offset: 6224 (0x1850) Flags: USED > XMIN: 1 CMIN: 0 XMAX: 667033 CMAX|XVAC: 6 OID: 2701 > Block Id: 7 linp Index: 3 Attributes: 2

Re: [ADMIN] postgres 8.2.6 core dump when initialising.

2008-04-14 Thread Tom Lane
Darren Reed <[EMAIL PROTECTED]> writes: > Some time ago I saw this message: > ERROR: index "pg_depend_reference_index" contains unexpected zero page > at block 23 > HINT: Please REINDEX it. > ERROR: index "table_p_hash_idx" contains unexpected zero page at block 7 > HINT: Please REINDEX it. [

Re: [ADMIN] postgres 8.2.6 core dump when initialising.

2008-04-14 Thread Darren Reed
Tom Lane wrote: Darren Reed <[EMAIL PROTECTED]> writes: > Program terminated with signal 11, Segmentation fault. > #0 0x0829845c in RelationCacheInitializePhase2 () at relcache.c:2400 > 2400LOAD_CRIT_INDEX(TriggerRelidNameIndexId); > (gdb) where > #0 0x0829845c in RelationCa

Re: [ADMIN] postgres 8.2.6 core dump when initialising.

2008-04-14 Thread Tom Lane
Darren Reed <[EMAIL PROTECTED]> writes: > Program terminated with signal 11, Segmentation fault. > #0 0x0829845c in RelationCacheInitializePhase2 () at relcache.c:2400 > 2400LOAD_CRIT_INDEX(TriggerRelidNameIndexId); > (gdb) where > #0 0x0829845c in RelationCacheInitializePhase