pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Db restore Error literal carriage return found hint use \r 4+ messages / 3 participants [nested] [flat]
* Db restore Error literal carriage return found hint use \r @ 2018-11-13 09:12 Om Prakash Jaiswal <op12om@yahoo.co.in> 0 siblings, 2 replies; 4+ messages in thread From: Om Prakash Jaiswal @ 2018-11-13 09:12 UTC (permalink / raw) To: Postgres General <pgsql-general@postgresql.org> 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Db restore Error literal carriage return found hint use \r @ 2018-11-13 14:27 Adrian Klaver <adrian.klaver@aklaver.com> parent: Om Prakash Jaiswal <op12om@yahoo.co.in> 1 sibling, 0 replies; 4+ messages in thread From: Adrian Klaver @ 2018-11-13 14:27 UTC (permalink / raw) To: op12om@yahoo.co.in <op12om@yahoo.co.in>; Postgres General <pgsql-general@postgresql.org> 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Db restore Error literal carriage return found hint use \r @ 2018-11-14 00:48 Om Prakash Jaiswal <op12om@yahoo.co.in> parent: Om Prakash Jaiswal <op12om@yahoo.co.in> 1 sibling, 1 reply; 4+ messages in thread From: Om Prakash Jaiswal @ 2018-11-14 00:48 UTC (permalink / raw) To: pgsql-admin Sent from Yahoo Mail on Android ----- 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.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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Db restore Error literal carriage return found hint use \r @ 2018-11-14 00:56 David G. Johnston <david.g.johnston@gmail.com> parent: Om Prakash Jaiswal <op12om@yahoo.co.in> 0 siblings, 0 replies; 4+ messages in thread From: David G. Johnston @ 2018-11-14 00:56 UTC (permalink / raw) To: op12om@yahoo.co.in <op12om@yahoo.co.in>; +Cc: pgsql-admin You were asked for more information, please provide it. A self-contained reproducing example (dump and restore) would be great. David J. ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2018-11-14 00:56 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2018-11-13 09:12 Db restore Error literal carriage return found hint use \r Om Prakash Jaiswal <op12om@yahoo.co.in> 2018-11-13 14:27 ` Adrian Klaver <adrian.klaver@aklaver.com> 2018-11-14 00:48 ` Om Prakash Jaiswal <op12om@yahoo.co.in> 2018-11-14 00:56 ` David G. Johnston <david.g.johnston@gmail.com>
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