pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Darren Reed <darrenr+postgres@fastmail.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
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 21:13:28 -0800
Message-ID: <47C4F178.1050102@fastmail.net> (raw)
In-Reply-To: <2862.1204040458@sss.pgh.pa.us>
References: <47C3AE1F.2010804@fastmail.net>
	<bf54be870802252233o5d7aa387o2c1eac2fcd2ae9fe@mail.gmail.com>
	<47C3E88B.8070803@fastmail.net>
	<2862.1204040458@sss.pgh.pa.us>

Tom Lane wrote:
> 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.
>   

How do I know which files those are?

I see nothing named that although grep suggests they did exist...
# grep pg_internal.init */*
Binary file base/1 matches
Binary file base/10818 matches
Binary file base/10819 matches

Darren




view thread (13+ messages)  latest in thread

Message-ID: <47C4F178.1050102@fastmail.net>
Permalink:  ../47C4F178.1050102@fastmail.net/
Also on:    postgresql.org/message-id/47C4F178.1050102@fastmail.net

 · 

reply

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: darrenr+postgres@fastmail.net, tgl@sss.pgh.pa.us, shoaibmir@gmail.com
  Subject: Re: How to reindex when unable to open relation?
  In-Reply-To: <47C4F178.1050102@fastmail.net>

* 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