Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gMZfF-0005z1-Bh for pgsql-general@arkaria.postgresql.org; Tue, 13 Nov 2018 14:27:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gMZfD-00028s-M4 for pgsql-general@arkaria.postgresql.org; Tue, 13 Nov 2018 14:27:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gMZfD-00028k-Da for pgsql-general@lists.postgresql.org; Tue, 13 Nov 2018 14:27:35 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gMZfA-0006ML-B4 for pgsql-general@postgresql.org; Tue, 13 Nov 2018 14:27:35 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 12F9F20E20; Tue, 13 Nov 2018 09:27:31 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Tue, 13 Nov 2018 09:27:31 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= subject:to:references:from:message-id:date:mime-version :in-reply-to:content-type:content-transfer-encoding; s=fm1; bh=1 btqec759al7F5YB6BDXSLtX20TopWDKi0eXx9pA8bw=; b=RV3b1AXOlUCLO0SKF yLwfSP/0mKxpFFD9qpSgEA0l5UYIr08AD+EKO/vO1C5mBOcDkB4LnZVsZD3v2zkH N7NVTkbQvIHwGn/RJ/gJfTY6jztfJlobXUCYWyRTzepeCV66cur3y55M0RrTKH3Y cokQcD1wu8XZL0HCQ53tJUWKh3aR7sw4I1q3MWev/wwbJeqmODvidFWRmdzGL7TS WN6G6Nrq+jRnE5jy70s/OeFQAjR/x/lagxBaBxgQs0hRDPpHTOWWrTFod6JyLMQX 3fTl1xkd133IFz+bXxfqy2ozbpyrm2MUpsBSWNU7tY2q+tUwKXTpbipVMSyxwLWb ZjZng== DKIM-Signature: v=1; a=rsa-sha256; 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-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; bh=1btqec759al7F5YB6BDXSLtX20TopWDKi0eXx9pA8 bw=; b=X0filkus3VelB3rIfnRuZB3HnSJtGKWXj9341tVkfXi1Dzt70pS3lKfLo 7dCqIwOexdNapqKApLzbPA3He10SSBXq/FILJ6m0Irb6ux5Y+tv32z8a6XgH5GVF /alFcHqzwCWJ/QqDHLCostc+w+DbjME4m4Cs5bYEBDNpEvAcRIRUMHBFtN06C+uE XD4F48mrlxa4d4hhr+oTsnfZaRVHL9NI4B4IQy8FztpB1OjlyRR2okZHaQI/DGfy l4XkxUegWyuvfsVhtQE+nRomxXhJUWem1QjAfFB1b6MDSFRGkiQhdThFfxJQDesv zpFb0A7pToio9JEq1KSpXnmXJ86zg== X-ME-Sender: X-ME-Proxy: Received: from [192.168.1.3] (unknown [71.212.134.3]) by mail.messagingengine.com (Postfix) with ESMTPA id 2BA7FE4678; Tue, 13 Nov 2018 09:27:30 -0500 (EST) Subject: Re: Db restore Error literal carriage return found hint use \r To: "op12om@yahoo.co.in" , Postgres General References: <2079778251.1525439.1542100356161.ref@mail.yahoo.com> <2079778251.1525439.1542100356161@mail.yahoo.com> From: Adrian Klaver Message-ID: <5480dca1-e5c8-eb48-212e-4ce400da3d8f@aklaver.com> Date: Tue, 13 Nov 2018 06:27:29 -0800 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.3.0 MIME-Version: 1.0 In-Reply-To: <2079778251.1525439.1542100356161@mail.yahoo.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 11/13/18 1:12 AM, Om Prakash Jaiswal wrote: > I am using postgresql 10.6 > While restore data using psql, error getting literal carriage return > found line no. 4446578 hint use \r Can you show the entire row(line)? > I used \i  and \r , still getting same error. > Backup size 35GB plain databack up. > Data type JSON in which I am getting error while copy ing in restore > operation. > > Please solve it. > > Regards > Om Prakash > Bangalore > > Sent from Yahoo Mail on Android > -- Adrian Klaver adrian.klaver@aklaver.com