Re: db-recovery after update 7.1 -> 7.4 failed - Mailing list pgsql-admin

From Bryan Encina
Subject Re: db-recovery after update 7.1 -> 7.4 failed
Date
Msg-id 000001c3b81f$f8e54da0$931f10ac@AT10111
Whole thread Raw
In response to db-recovery after update 7.1 -> 7.4 failed  (Dominique Fenenr <dfenner@gmx.de>)
List pgsql-admin
Hi Dominique,

>ERROR:  literal carriage return found in data
>HINT:  Use "\r" to represent carriage return.
>CONTEXT:  COPY netjuke_tracks, line 3312: "3196 940     335     4
>21 Things I Want In A Lover 4991999
>207     1       2002    2003-05-16 21:24:08+02  192     44100
>MPEG ..."
>
>"phpbb_posts_text" and "netjuke_tracks" don't have no rows anymore which
>is pretty bad. I had a look at the backup-file, the data is still
>there. Do I have any chance to recover the data? Perhaps by
>manipulating the backup file?

Sounds like a problem I had a week or two ago that I posted to the novice
list.  Here's a link to how I got it resolved.
http://archives.postgresql.org/pgsql-novice/2003-11/msg00158.php
HTH,
-b


pgsql-admin by date:

Previous
From: "Hector"
Date:
Subject: unsubscribe
Next
From: Christopher Browne
Date:
Subject: Re: pg_restore and transaction id wraparound