Re: How to reindex when unable to open relation? - Mailing list pgsql-admin

From Tom Lane
Subject Re: How to reindex when unable to open relation?
Date
Msg-id 2862.1204040458@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to reindex when unable to open relation?  (Darren Reed <darrenr+postgres@fastmail.net>)
Responses Re: How to reindex when unable to open relation?
List pgsql-admin
Darren Reed <darrenr+postgres@fastmail.net> writes:
> Hmmm, from the logfile, signal 11, so it core dumped...
> Of course the default built binary is -O2...
> (gdb) where
> #0  0x082114b8 in RelationCacheInitializePhase2 ()
> #1  0x0821fa67 in InitPostgres ()
> #2  0x081a7d8b in PostgresMain ()
> #3  0x08184882 in ServerLoop ()
> #4  0x0818545c in PostmasterMain ()
> #5  0x0814be1f in main ()

Hm, if you are really lucky, this is because of a corrupt
pg_internal.init file.  Fortunately for you, that's just a cache;
try removing (all of the) pg_internal.init files and see if the
DB will start.

            regards, tom lane

pgsql-admin by date:

Previous
From: Ron Mayer
Date:
Subject: Re: Latest postgres stable version
Next
From: Darren Reed
Date:
Subject: Retrieving data from the data files.