Db restore Error literal carriage return found hint use \r

From: Om Prakash Jaiswal <op12om(at)yahoo(dot)co(dot)in>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Db restore Error literal carriage return found hint use \r
Date: 2018-11-13 09:12:36
Message-ID: 2079778251.1525439.1542100356161@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrey Zhidenkov 2018-11-13 09:18:10 Re: hot_standby_feedback parameter doesn't work
Previous Message Achilleas Mantzios 2018-11-13 07:52:07 Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC in pg_wal "No space left on device"

Browse pgsql-general by date

  From Date Subject
Next Message talk to ben 2018-11-13 10:50:09 Re: pg9.6 when is a promoted cluster ready to accept "rewind" request?
Previous Message Adrian Klaver 2018-11-12 22:12:33 Re: Is pg_restore in 10.6 working?