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