Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1E6172E0032 for ; Tue, 26 Feb 2008 11:41:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 21659-09 for ; Tue, 26 Feb 2008 11:40:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 6EBF02E0030 for ; Tue, 26 Feb 2008 11:41:02 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m1QFewYQ002863; Tue, 26 Feb 2008 10:40:58 -0500 (EST) To: Darren Reed cc: Shoaib Mir , pgsql-admin@postgresql.org Subject: Re: How to reindex when unable to open relation? In-reply-to: <47C3E88B.8070803@fastmail.net> References: <47C3AE1F.2010804@fastmail.net> <47C3E88B.8070803@fastmail.net> Comments: In-reply-to Darren Reed message dated "Tue, 26 Feb 2008 02:23:07 -0800" Date: Tue, 26 Feb 2008 10:40:58 -0500 Message-ID: <2862.1204040458@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/344 X-Sequence-Number: 28418 Darren Reed 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