Subject: Re: Re: ERROR while creating new user - could not open relation
 mapping file global/pg_filenode.map
To: Sribeiro <info@simetriastudio.com>, pgsql-sql@postgresql.org
References: <1449103913630-5876012.post@n5.nabble.com>
 <565F9916.8050800@aklaver.com> <1449107178100-5876028.post@n5.nabble.com>
 <565FCD37.3080804@aklaver.com> <1449147608774-5876118.post@n5.nabble.com>
 <566060E1.6070808@aklaver.com> <1449160418085-5876161.post@n5.nabble.com>
 <56607275.4060404@aklaver.com> <1449167361158-5876168.post@n5.nabble.com>
 <56609751.1000500@aklaver.com> <1449171498579-5876183.post@n5.nabble.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <5660A1F3.1080408@aklaver.com>
Date: Thu, 3 Dec 2015 12:11:31 -0800
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:38.0) Gecko/20100101
 Thunderbird/38.4.0
MIME-Version: 1.0
In-Reply-To: <1449171498579-5876183.post@n5.nabble.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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


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