Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map

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.
>
> 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.

Hmm, this does not look promising:

http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/utils/cache/relmapper.c;h=c151b92dfc3d795aaa9455022512a2ba3479d7eb;hb=HEAD

"/*
* The map file is critical data: we have no automatic method for
recovering
* from loss or corruption of it. ..."

>
> Sergio
>
>
>
> --
> View this message in context: http://postgresql.nabble.com/ERROR-while-creating-new-user-could-not-open-relation-mapping-file-global-pg-filenode-map-tp5874842.html
> Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com