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 1gMjMZ-0003Ng-1D for pgsql-admin@arkaria.postgresql.org; Wed, 14 Nov 2018 00:48:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gMjMW-00089q-QO for pgsql-admin@arkaria.postgresql.org; Wed, 14 Nov 2018 00:48:56 +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 1gMjMR-0007ea-FY for pgsql-admin@lists.postgresql.org; Wed, 14 Nov 2018 00:48:52 +0000 Received: from sonic303-24.consmr.mail.sg3.yahoo.com ([106.10.242.41]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gMjMM-0003xh-Su for pgsql-admin@postgresql.org; Wed, 14 Nov 2018 00:48:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s2048; t=1542156519; bh=8Kf+oP4idpDfr2/AEaU9VWF+xfx4NDF3g3+h2la8tDg=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=ugrGr5Q0af+4q/MiH7pm01914fGrVvptPngTAUgOtjxTgZBRyAAGZ8cDYFO+W3yZ4BIecf9sEFCv5c5Xm5cAs75c86rLRlIWgx92fAqjVUO5UvcCP97kZKg/hFnkZYtmTfjNV7tPxgVqIueCQaMYRk+3qN80aUQr8tBxkx8wcd+k+ZkIPQNi286qj90ATWooBoyvkfib0H+LlGFg/4umZT8U5CfrsueWFzeZsxOSvARf2NDQsYBFMS6rHMGmrH9MsaCw67E+Zp0S3VM77qph+qg5nH9OkWDA1KWVDbZrvP1TXwATDqvbAl5gy+sL7gyjltCHQNNs1DnZNH7wXpByeA== X-YMail-OSG: pnCYC.UVM1no4bnoIXyjiEaI.HbPLlXg5thfsUAuti2yEpFoReCtGazyTJYAHIX AQzWWtoRFFDCjNJQobkPABsQD1X3KGr17N7j.qGWaDUDxCs.OfL8.o0c7nlalzpDsb4Iu.jasieR gITfiXWUVNTfYlYMBhrKf7kZgxvGZntt6CcQHPo2dw4kdT3.dGt2sv1g3Ji5XooFQorCMEm39bCV LCPzjVIn4qjw5Y2uMQeNfiuGybN4YvjwLtEQeEFxjkJmpiF.uI2r_Z9DbSfpPffY4bHtUjzpoLaD aXXTi_qlORD6V6f9q2VsN2Ne2aGALcESSHEsOrPPac.uSrDXx9mx0AzHwWYFmJ5uBQfNMM8z4nNz pkYF62zfXii4EHbpgqPI2vAyqXB9HM0VRcBbzWaB.hheg5hDWHBGjRBhx2mTzLox4mlQesSKXs8k J73lg4AOs3yW.JT1FmDKjbw0Bf0.cFz7jX0WgTNEu8Xw_NzgDSd2SwPbGlrBaCTzRwFCYy5oXhAU oBBIxRWXMpznqam3RJmgup2yGBuff6eDsPwBFwUpTiRt4UnfioFKe2ZPTS0cMW80sseAO2qNJ9it e9GUNGe6KcnmJ3O63297wgKsIRJF45G8cIVRDaX9m804SHshViTKVgn4kaioYdtLZ2VIcImKceFA dJt12BQGWGFYanmWRgqopm4XNBBB9h_WJDer.qVaIDKULb2Xv3l4jb77YPecYJ2df9rbjBVMvCpP SXFPgS3LxKSV1Jk10nJZALz4rOlAoQFqpTq.febzJCs8s0ORENhG3i1V2HqXndKAZgkv6.i61lqY .qeW3zCjGQW449TVwPpn7oZOVgfqgJnNcEXjV5qS9F88uJVuEa0tZjY6IjmjnwMYb00Gjfk74DAM hoUS4B8IVR0el3319UuWXs3JGiCl6TfC5eFvxvAd8PWML4evrJKTZVOcnUwud2pQhIMqbw7o3hht TFRfPeLEyimhxqEyhjcIhTq7pJcKgNomjGYtcdmGLN5OYuCEJskxacRZEwo6vl5LqJ1vHS3nShQA rMBsCnSvl Received: from sonic.gate.mail.ne1.yahoo.com by sonic303.consmr.mail.sg3.yahoo.com with HTTP; Wed, 14 Nov 2018 00:48:39 +0000 Date: Wed, 14 Nov 2018 00:48:35 +0000 (UTC) From: Om Prakash Jaiswal Reply-To: "op12om@yahoo.co.in" To: Pgsql-admin Message-ID: <901888138.37857.1542156515042@mail.yahoo.com> In-Reply-To: <2079778251.1525439.1542100356161@mail.yahoo.com> References: <2079778251.1525439.1542100356161.ref@mail.yahoo.com> <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_37856_1157869638.1542156515040" X-Mailer: WebService/1.1.12729 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: 3201 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_37856_1157869638.1542156515040 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Sent from Yahoo Mail on Android=20 =20 ----- Forwarded Message ----- From: "Om Prakash Jaiswal" To: "Postgres General" Cc: Sent: Tue,= Nov 13, 2018 at 14:42 Subject: Db restore Error literal carriage return fo= und hint use \r I am using postgresql 10.6While restore data using psql, e= rror getting literal 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 r= estore operation. Please solve it. Regards=C2=A0Om PrakashBangalore Sent from Yahoo Mail on Android =20 ------=_Part_37856_1157869638.1542156515040 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Sent from Yahoo Mail on Android
----- Forward= ed Message -----
From: "Om Prakash Jaiswal" <op12om@ya= hoo.co.in>
To: "Postgres General" <pgsql-general@po= stgresql.org>
Cc:
= Sent: Tue, Nov 13, 2018 at 14:42
Subject: Db restore = Error literal carriage return found hint use \r
I am using po= stgresql 10.6
While res= tore data using psql, error getting literal carriage return found line no. = 4446578 hint use \r 
I used \i  and \r , still getting same error.
Backup size 35GB plain databack = up.
Data type JSO= N in which I am getting error while copy ing in restore operation.

Please solve it.

Regards 
Om Prakash
------=_Part_37856_1157869638.1542156515040--