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.

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