From: Adrian Klaver <adrian.klaver@aklaver.com>
To: op12om@yahoo.co.in <op12om@yahoo.co.in>
To: Postgres General <pgsql-general@postgresql.org>
Subject: Re: Db restore Error literal carriage return found hint use \r
Date: Tue, 13 Nov 2018 06:27:29 -0800
Message-ID: <5480dca1-e5c8-eb48-212e-4ce400da3d8f@aklaver.com> (raw)
In-Reply-To: <2079778251.1525439.1542100356161@mail.yahoo.com>
References: <2079778251.1525439.1542100356161.ref@mail.yahoo.com>
<2079778251.1525439.1542100356161@mail.yahoo.com>
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__Android...;
--
Adrian Klaver
adrian.klaver@aklaver.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: adrian.klaver@aklaver.com, op12om@yahoo.co.in, pgsql-general@postgresql.org
Subject: Re: Db restore Error literal carriage return found hint use \r
In-Reply-To: <5480dca1-e5c8-eb48-212e-4ce400da3d8f@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox