Re: postgres 8.2.6 core dump when initialising. - Mailing list pgsql-admin

From Tom Lane
Subject Re: postgres 8.2.6 core dump when initialising.
Date
Msg-id 1071.1208179948@sss.pgh.pa.us
Whole thread Raw
In response to postgres 8.2.6 core dump when initialising.  (Darren Reed <darrenr+postgres@fastmail.net>)
Responses Re: postgres 8.2.6 core dump when initialising.  (Darren Reed <darrenr+postgres@fastmail.net>)
List pgsql-admin
Darren Reed <darrenr+postgres@fastmail.net> writes:
> Program terminated with signal 11, Segmentation fault.
> #0  0x0829845c in RelationCacheInitializePhase2 () at relcache.c:2400
> 2400                    LOAD_CRIT_INDEX(TriggerRelidNameIndexId);
> (gdb) where
> #0  0x0829845c in RelationCacheInitializePhase2 () at relcache.c:2400

This appears to be the exact same problem you reported back in February:
http://archives.postgresql.org/pgsql-admin/2008-02/msg00370.php

I'm thinking there must be something about what you are doing that
is triggering this issue.  Care to give us a full data dump on your
maintenance habits?

It might be useful if we could look at a pg_filedump dump of your
pg_class table, too.
http://sources.redhat.com/rhdb/

            regards, tom lane

pgsql-admin by date:

Previous
From: Baudrion Philippe
Date:
Subject: Re: Retore Postgres DB without dump
Next
From: Darren Reed
Date:
Subject: Re: postgres 8.2.6 core dump when initialising.