agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Sribeiro <info@simetriastudio.com>
To: pgsql-sql@postgresql.org
Subject: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map
Date: Mon, 23 Nov 2015 12:13:46 -0800
Message-ID: <5653737A.30908@aklaver.com> (raw)
In-Reply-To: <1448307482990-5874842.post@n5.nabble.com>
References: <1448307482990-5874842.post@n5.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

On 11/23/2015 11:38 AM, Sribeiro wrote:
> Hi All,
>
> I am trying to use postgresql with a Rails app, and I am having an issue
> creating a new user/password.
> I get the following message:
> createuser: could not connect to database postgres: FATAL: could not open
> relation mapping file "global/pg_filenode.map": No such file or directory
>
> I believe I might of accidentally deleted this file and after sudo
> uninstalling Postgres with Brew and re-installing I still cannot get it back
> or to work.

So as part of the uninstall/install did you do initdb over again or are 
you reusing the previous cluster directory?

Have you looked in the $PGDATA/global directory to see if 
pg_filenode.map is indeed there or not?

Do you have a backup of the database(s)?


>
> I am using the latest version of Postgres and I'm on Mac OS X 10.10.4
>
> Any idea on how I can fix this issue? Thanks so much in advance.
>
> Sergio
>
>
>
> --
> View this message in context: http://postgresql.nabble.com/ERROR-while-creating-new-user-could-not-open-relation-mapping-file-glob...
> Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
>
>


-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
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: <5653737A.30908@aklaver.com>
Permalink:  ../5653737A.30908@aklaver.com/
Also on:    postgresql.org/message-id/5653737A.30908@aklaver.com

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: adrian.klaver@aklaver.com, info@simetriastudio.com
  Subject: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map
  In-Reply-To: <5653737A.30908@aklaver.com>

* 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