pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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: Wed, 27 Feb 2008 00:34:37 -0500
Message-ID: <14210.1204090477@sss.pgh.pa.us> (raw)
In-Reply-To: <47C4F353.4040304@fastmail.net>
References: <47C3AE1F.2010804@fastmail.net>
	<bf54be870802252233o5d7aa387o2c1eac2fcd2ae9fe@mail.gmail.com>
	<47C3E88B.8070803@fastmail.net>
	<2862.1204040458@sss.pgh.pa.us>
	<47C4F178.1050102@fastmail.net>
	<14002.1204089578@sss.pgh.pa.us>
	<47C4F353.4040304@fastmail.net>

Darren Reed <darrenr+postgres@fastmail.net> writes:
>>> How do I know which files those are?
>> 
>> find $PGDATA -name pg_internal.init

> Doesn't exist.

Sucks to be you, then :-(

I'm curious though exactly where the failure is, because there's not
much in RelationCacheInitializePhase2 that looks like it could crash,
other than the init-file reading (I assume load_relcache_init_file
got inlined into RelationCacheInitializePhase2).  Do you want to try
rebuilding the backend with --enable-debug so we can get a better
traceback?

			regards, tom lane



view thread (13+ messages)  latest in thread

Message-ID: <14210.1204090477@sss.pgh.pa.us>
Permalink:  ../14210.1204090477@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/14210.1204090477@sss.pgh.pa.us

 · 

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: 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: <14210.1204090477@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