Обсуждение: Db restore Error literal carriage return found hint use \r

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

Bangalore

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.