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

On 12/03/2015 11:38 AM, Sribeiro wrote:
> 1st command I get:
> /[~ (master)]$ ls -al /Users/Serge/Desktop/
> total 77392
> drwx------+ 13 Serge  staff       442 Dec  3 14:35 .
> drwxr-xr-x+ 43 Serge  staff      1462 Nov  1 00:04 ..
> -rw-r--r--@  1 Serge  staff     10244 Dec  3 14:35 .DS_Store
> drwxr-xr-x   8 Serge  staff       272 Dec  3 11:35 Adobe CC
> -rw-r--r--@  1 Serge  staff       275 Nov 23 21:00 Could not open relation
> mapping file "global-pg_filenode.map" · .webloc
> -rw-r--r--@  1 Serge  staff   1650428 Dec  3 01:46 IMG_0568.JPG
> -rw-r--r--@  1 Serge  staff   2161564 Dec  3 01:51 IMG_0569.JPG
> -rw-r--r--@  1 Serge  staff       280 Nov 23 21:00 PostgreSQL - PostgreSQL -
> sql | Mailing List Archive.webloc
> -rw-r--r--@  1 Serge  staff       277 Nov 23 21:00 PostgreSQL | dBforums –
> Everything on Databases, Design, Develop.webloc
> -rw-r--r--@  1 Serge  staff    483734 Dec  2 14:28 TST_HeadSection_2015.jpg
> -rw-r--r--@  1 Serge  staff   6532736 Nov 29 12:24 emt_Home.psd
> drwx------  27 Serge  staff       918 Dec  1 21:57 postgres
> -rw-r--r--@  1 Serge  staff  28683898 Dec  3 11:20 x-mas_card.ai/
>
> 2nd command i get:
> /[~ (master)]$ ps ax| grep post
>    303   ??  S      0:00.07 /usr/local/opt/postgresql/bin/postgres -D
> /usr/local/var/postgres -r /usr/local/var/postgres/server.log
>    387   ??  Ss     0:00.02 postgres: checkpointer process
>    388   ??  Ss     0:00.44 postgres: writer process
>    389   ??  Ss     0:00.44 postgres: wal writer process
>    390   ??  Ss     0:00.22 postgres: autovacuum launcher process
>    391   ??  Ss     0:00.39 postgres: stats collector process
>   3922 s000  R+     0:00.00 grep post/
>
From a previous post:

"After running your command i get:
PATH=/Users/Serge/.rbenv/shims:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin"

All I got left is that the postgres/ in /Users/Serge/Desktop/ is causing 
the problem. I would get rid of that directory, you said previously 
there was nothing important in it. Either just delete it or if move it 
off the machine onto a USB drive, etc. I would then restart the Postgres 
server and try connecting with psql.

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


-- 
Adrian Klaver
adrian.klaver@aklaver.com