Re: How to reindex when unable to open relation?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Darren Reed <darrenr+postgres(at)fastmail(dot)net>
Cc: Shoaib Mir <shoaibmir(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: How to reindex when unable to open relation?
Date: 2008-02-26 15:40:58
Message-ID: 2862.1204040458@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Darren Reed <darrenr+postgres(at)fastmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Carol Walter 2008-02-26 19:41:45 encoding???
Previous Message Ron Mayer 2008-02-26 12:45:32 Re: Latest postgres stable version