From: Tom Lane <tgl@sss.pgh.pa.us>
To: Darren Reed <darrenr+postgres@fastmail.net>
Cc: Shoaib Mir <shoaibmir@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to reindex when unable to open relation?
Date: Tue, 26 Feb 2008 10:40:58 -0500
Message-ID: <2862.1204040458@sss.pgh.pa.us> (raw)
In-Reply-To: <47C3E88B.8070803@fastmail.net>
References: <47C3AE1F.2010804@fastmail.net>
<bf54be870802252233o5d7aa387o2c1eac2fcd2ae9fe@mail.gmail.com>
<47C3E88B.8070803@fastmail.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, darrenr+postgres@fastmail.net, shoaibmir@gmail.com
Subject: Re: How to reindex when unable to open relation?
In-Reply-To: <2862.1204040458@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox