Db restore Error literal carriage return found hint use \r

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
<https://go.onelink.me/107872968?pid=InProduct&amp;c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&amp;af_wl=ym&amp;af_sub1=Internal&amp;af_sub2=Global_YGrowth&amp;af_sub3=EmailSignature&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

Sent from Yahoo Mail on Android

----- Forwarded Message ----- From: "Om Prakash Jaiswal" <op12om@yahoo.co.in> To: "Postgres General" <pgsql-general@postgresql.org> Cc: Sent: Tue, Nov 13, 2018 at 14:42 Subject: Db restore Error literal carriage return found hint use \r I am using postgresql 10.6While restore 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 JSON in which I am getting error while copy ing in restore operation.
Please solve it.
Regards Om PrakashBangalore

Sent from Yahoo Mail on Android

You were asked for more information, please provide it. A self-contained
reproducing example (dump and restore) would be great.

David J.