Re: db-recovery after update 7.1 -> 7.4 failed

Поиск
Список
Период
Сортировка
От Bryan Encina
Тема Re: db-recovery after update 7.1 -> 7.4 failed
Дата
Msg-id 000001c3b81f$f8e54da0$931f10ac@AT10111
обсуждение исходный текст
Ответ на db-recovery after update 7.1 -> 7.4 failed  (Dominique Fenenr <dfenner@gmx.de>)
Список 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 по дате отправления:

Предыдущее
От: "Hector"
Дата:
Сообщение: unsubscribe
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: pg_restore and transaction id wraparound