Postgres Pro
Downloads
Home   >   mailing lists

Db restore Error literal carriage return found hint use \r - Mailing list pgsql-admin

From Om Prakash Jaiswal
Subject Db restore Error literal carriage return found hint use \r
Date
Msg-id 901888138.37857.1542156515042@mail.yahoo.com
Whole thread Raw
Responses Db restore Error literal carriage return found hint use \r  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view



----- 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.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

pgsql-admin by date:

Previous
From:
Date:
Subject: RE: Ora2pg Not Getting Installed- Please Provide Inputs
Next
From: "David G. Johnston"
Date:
Subject: Db restore Error literal carriage return found hint use \r