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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: "op12om(at)yahoo(dot)co(dot)in" <op12om(at)yahoo(dot)co(dot)in>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Db restore Error literal carriage return found hint use \r
Date: 2018-11-13 14:27:29
Message-ID: 5480dca1-e5c8-eb48-212e-4ce400da3d8f@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2018-11-13 15:35:03 Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC in pg_wal "No space left on device"
Previous Message Achilleas Mantzios 2018-11-13 13:20:48 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 Adrian Klaver 2018-11-13 14:43:20 Re: Plpgsql search_path issue going from 9.3 to 9.6
Previous Message George Woodring 2018-11-13 14:27:28 Re: Plpgsql search_path issue going from 9.3 to 9.6