Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1a4Vtr-00062p-DV for pgsql-sql@arkaria.postgresql.org; Thu, 03 Dec 2015 15:34:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1a4Vtq-0000O6-LB for pgsql-sql@arkaria.postgresql.org; Thu, 03 Dec 2015 15:34:26 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1a4Vtp-0000Nc-Aw for pgsql-sql@postgresql.org; Thu, 03 Dec 2015 15:34:25 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1a4Vtm-0000Ag-B6 for pgsql-sql@postgresql.org; Thu, 03 Dec 2015 15:34:23 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 34ED420148 for ; Thu, 3 Dec 2015 10:34:21 -0500 (EST) Received: from frontend1 ([10.202.2.160]) by compute3.internal (MEProxy); Thu, 03 Dec 2015 10:34:21 -0500 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=aklaver.com; h= content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-sasl-enc :x-sasl-enc; s=mesmtp; bh=0uuTPIkG3/uBne3LNA59Y/ZOzyw=; b=DYo500 5jLFY79L/pQIdMNMFtBXOB+vcGQZn0XfgspuVW71dPnHd4NQ0AKTQ9ILWvbi2CW+ 5WTN+9AQTv2CuCcLGpYJ3oPu2jLF6203/KbEtrY2z/cfbG0XGOJprew0DlT2yr3y p+dXefLWYFbUZ16YBZw5MRTJUk+daF6RhYVmI= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-sasl-enc:x-sasl-enc; s=smtpout; bh=0uuTPIkG3/uBne3 LNA59Y/ZOzyw=; b=py267HX6edTLDOF7aYEMIfaoSVkwSHGke1rLpdVOjWkhZkv YRNqD1kfY42q6n0bJPncrdaF9uGUBj2i3n5p5WyMFXG1CwYbU7ABnDhCrMKPnQDw CkhLtc15T/w1FRMtKldE0GwzhjInBPfUmdhtVWq44gfvhy9My0tfbviVeRgo= X-Sasl-enc: DNKg7/TaKTEcNcLw2Yae1hhHvoCkZA43RK4pQJcihPZU 1449156860 Received: from [192.168.1.2] (65-102-182-223.tukw.qwest.net [65.102.182.223]) by mail.messagingengine.com (Postfix) with ESMTPA id 9A2D8C016DB; Thu, 3 Dec 2015 10:34:20 -0500 (EST) Subject: Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map To: Sribeiro , pgsql-sql@postgresql.org References: <1449099285158-5875994.post@n5.nabble.com> <565F81FB.8080106@aklaver.com> <1449100566874-5875998.post@n5.nabble.com> <565F8951.7090505@aklaver.com> <1449102851217-5876007.post@n5.nabble.com> <565F8F44.2060200@aklaver.com> <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> From: Adrian Klaver Message-ID: <566060E1.6070808@aklaver.com> Date: Thu, 3 Dec 2015 07:33:53 -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: <1449147608774-5876118.post@n5.nabble.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org On 12/03/2015 05:00 AM, Sribeiro wrote: > The time stamp says it was created on Nov 23, and last modified on Dec 1. > It's inside the copy of the old postgres folder on my desktop. My suspicion is you have crossed wires here, two Postgres clusters and confusion about which one is the actual 'live' one. A vague answer, but maybe a starting point for figuring out what is going on. To reprise: 1) You have a fresh install at /usr/local/var/postgres. At that location you have no server.log, correct? 2) You have the old install on your Desktop and it has many server.logs, including the one timestamped above. The Desktop does not exist outside the file system, so can you find the actual path to this install? Also, I am guessing this install is the one without the pg_filenode.map in $PGDATA/global, correct? > > > > -- > View this message in context: http://postgresql.nabble.com/ERROR-while-creating-new-user-could-not-open-relation-mapping-file-global-pg-filenode-map-tp5874842p5876118.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