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 1gMUkh-0004CG-W3 for pgsql-general@arkaria.postgresql.org; Tue, 13 Nov 2018 09:12:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gMUkf-0004Bd-Q7 for pgsql-general@arkaria.postgresql.org; Tue, 13 Nov 2018 09:12:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gMUkf-0004BW-7N for pgsql-general@lists.postgresql.org; Tue, 13 Nov 2018 09:12:53 +0000 Received: from sonic310-19.consmr.mail.sg3.yahoo.com ([106.10.244.139]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gMUkW-0007GE-Ma for pgsql-general@postgresql.org; Tue, 13 Nov 2018 09:12:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s2048; t=1542100358; bh=0AAlXHWATc/1c7YkWR7A9AGXXEQefUKCTm5V5Bv0u1A=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=dj/vSeJG7BY0VV1pyneLCSessuSxf4nVOQU1g3F6LDNiDNdr873SB86J/L/747xYxt4jtw9TeJed1LH9ebMfj+Kp5CW59NfYz3UXKCtGGAvSUecxmguWLzxZ0pHPExIEpevc+XsR86NEVO7OsvmAiv+lH8FBnmCyVPYjiNonC9COeKXb/8uAQ923pJOpFzZcC1tfZZ4ipjPhycwOc0D+Fd5x97XJyq3UKqM6eV0LH1uJ3vrHP9s6YjhfpucmDsGdr5TzcFHuUCK2UJG8lskl/S8QcASWyTh/jSashQbDUCQuWnjCb7ThegAupe3wFltehvwUcN+r7GXEufLYu0XJMw== X-YMail-OSG: u1Aq0xEVM1k9MB_wzfeGMIlvmUnpTwusVsAG80J9tQ_TvbWMdtAfX8o5o_osPHX rvcQ9YVz_yBPB3s_SGh0ytB97CnDKq5AUA57Ufk5Oac9hzuUaDC.aDYClOGU2mSngaGnnNdILcw0 OrHbKrFZe9A.Z1isXANYdSyUfifivmeMUImrMT4CbCSoSuOtth_i_R.9RZkDZC0NaSoMXJvIWVbi JcTboFWSg3ZnFI8jzYu4kIfb4eHgkE2VtNtz1BbMPJr6r4jX6_aoS6Qaitaat8eFjKa_wYrylK43 LWYqe2_DKDMxOWL_qxoUZyeAON6GKO1.RA28pcQn1Aw7JvmvNl_GCQUex17D_7IWMa4I.L7SVizs cunQLSlfQ9GQJ100LURH1yEtIcNmoIDAfiGfza2TnoJ3tMA6MBc2RtTS6s0NMjPLBXCXNvNAoeU2 GhDyujUH6LUMpZDhPwFqyUURF3FRImbDGrqQTnNQg6NH6Z306I8oUJuh.2wQVM0kN.vz9doOj8fb wqk4EwqXEHkoAKXYnnJLulnenmYVRvm90fUKu5kc2hGXtAy5MA5KCFooowqc9pyIv5xVqYnbyNjV B5aMyMnjlGudkRtmj8GrtJEmBMqhUPq9Z3UZ3xf5ebHVPEEETDZ3vNH25YGJmOAKKvL8qp0VMLlG LCusCnh2qdv7E_T6YDHdPzd8lvGdBaDeEF_WXVDGB8Zb3ICfrSpWvz4dU8tpS5tQnCRzlvUJqQ4k iHuluy4sHg6vWB9b.UBgRe8448JEl339Gu7Uwmf8nla9ryLnv9DhwhacDAdqX24uK_dnqFV_hyr5 iGhG9RvkDwx6IrL32EgimINSZszNl86Q9S5kEY12VUtXVRnHLeggOTQucsnOMHLuHp9vZdSi52Gj qB84sdLJn2tprtujuOrpXsn1MBhsDBac9TLtrYxOYQGWtKxg52e8LSNXbsbXeK69D5iDWuRdAeE3 zWSPDFUl_dP7Y1g7PMUk0.YtIndGbZVbJ9HGbhUS4Z0__hvsRklokmQlr0hVW5wMwjE31PsNnM4y YW8Sh5jWwB7GF8GxCjQHJ Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.sg3.yahoo.com with HTTP; Tue, 13 Nov 2018 09:12:38 +0000 Date: Tue, 13 Nov 2018 09:12:36 +0000 (UTC) From: Om Prakash Jaiswal Reply-To: "op12om@yahoo.co.in" To: Postgres General Message-ID: <2079778251.1525439.1542100356161@mail.yahoo.com> Subject: Db restore Error literal carriage return found hint use \r MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1525438_1837773997.1542100356160" References: <2079778251.1525439.1542100356161.ref@mail.yahoo.com> X-Mailer: WebService/1.1.12732 YahooMailAndroidMobile YMobile/1.0 (com.yahoo.mobile.client.android.mail/5.34.0; Android/6.0.1; MMB29M; land; Xiaomi; Redmi 3S; 4.97; 1280x720;) Content-Length: 1979 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1525438_1837773997.1542100356160 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I am using postgresql 10.6While restore data using psql, error getting lite= ral carriage return found line no. 4446578 hint use \r=C2=A0I used \i=C2=A0= 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=C2=A0Om PrakashBangalore Sent from Yahoo Mail on Android ------=_Part_1525438_1837773997.1542100356160 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I am using postgresql 10.6
While restore data using psql, error getting literal carriage return fo= und line no. 4446578 hint use \r 
I used \i  and \r , still getting same error.
Backup size 35GB pl= ain databack up.
= Data type JSON in which I am getting error while copy ing in restore operat= ion.

Please solve it.

Regards 
Om Prakash
------=_Part_1525438_1837773997.1542100356160--