Postgres Pro
Downloads
Home   >   mailing lists

Thread: Db restore Error literal carriage return found hint use \r

Db restore Error literal carriage return found hint use \r

From
Om Prakash Jaiswal
Date:
I am using postgresql 10.6
While 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 Prakash

Re: Db restore Error literal carriage return found hint use \r

From
Adrian Klaver
Date:
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