agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Sribeiro <info@simetriastudio.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map
Date: Tue, 24 Nov 2015 19:10:35 -0300
Message-ID: <20151124221035.GJ4073@alvherre.pgsql> (raw)
In-Reply-To: <32161.1448402563@sss.pgh.pa.us>
References: <1448307482990-5874842.post@n5.nabble.com>
	<565378B4.5080801@aklaver.com>
	<1448311158958-5874860.post@n5.nabble.com>
	<1448386072130-5874934.post@n5.nabble.com>
	<32161.1448402563@sss.pgh.pa.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

Tom Lane wrote:
> Sribeiro <info@simetriastudio.com> writes:
> > Anyone has any idea what i need to do fix this issue?
> 
> You don't have an up-to-date backup, eh?
> 
> You might be able to fix this by doing a fresh initdb (targeting some
> other location for the data directory, of course, but being careful
> to use the exact same Postgres version) and then copying the
> global/pg_filenode.map file out of that data directory and into your
> broken one.  This would only work if you've never done a VACUUM FULL on
> any of the shared catalogs in the existing data directory, so it's far
> from guaranteed to work; but it's worth a try.

It's relatively easy to identify the files corresponding to each
catalog, even when they have been mapped; just pg_filedump the files
until you find ones that match the expected number of attributes, and
disambiguate based on which attributes have HEAP_VARWIDTH and such.
Then you just need to cp the right files to the default names using the
default map created in the freshly initdb'd cluster.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

view thread (52+ messages)  latest in thread

Message-ID: <20151124221035.GJ4073@alvherre.pgsql>
Permalink:  ../20151124221035.GJ4073@alvherre.pgsql/
Also on:    postgresql.org/message-id/20151124221035.GJ4073@alvherre.pgsql

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-sql@postgresql.org
  Cc: alvherre@2ndquadrant.com, tgl@sss.pgh.pa.us, info@simetriastudio.com
  Subject: Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map
  In-Reply-To: <20151124221035.GJ4073@alvherre.pgsql>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox