Postgres Pro
Downloads
Home   >   mailing lists

Re: Db restore Error literal carriage return found hint use \r - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Db restore Error literal carriage return found hint use \r
Date
Msg-id 5480dca1-e5c8-eb48-212e-4ce400da3d8f@aklaver.com
Whole thread Raw
In response to Db restore Error literal carriage return found hint use \r  (Om Prakash Jaiswal <op12om@yahoo.co.in>)
List pgsql-general
Tree view 
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&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature>


-- 
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: George Woodring
Date:
Subject: Re: Plpgsql search_path issue going from 9.3 to 9.6
Next
From: Adrian Klaver
Date:
Subject: Re: Plpgsql search_path issue going from 9.3 to 9.6