Re: Restore SQL_ASCII backup...

Le mercredi 2 décembre 2009 à 07:34:09, Brian Myers a écrit :
> Hi all,
>
> I'm trying to restore an old backup (7.1.4) into a new PG database (8.4).
> There are errors with some of the RI and sequences, but those are easy to
> fix.
>
> The problem is that one table in the DB has TEXT fields in it and these
> seem to be sensitive to the DB encoding. The default in the days of 7.1.4
> was SQL_ASCII. The new default is UTF-8. pg_restore won't load the old
> table data into the new table.
>
> I tried creating a new DB with encoding SQL_ASCII and restoring the backup
> into that, but I get the error:
>
> pg_restore: [archiver (db)] COPY failed: ERROR: literal carriage return
> found in data HINT: Use "\r" to represent carriage return.
> CONTEXT: COPY encounters, line 9711: ""
> WARNING: errors ignored on restore: 1
> tarka(at)jetty:~$ psql -d triagedb
> psql (8.4.1)
> Type "help" for help.
>
> The other problem is that the backups are in compressed format because I
> needed to save space on that system, so I can't just edit the text of the
> data directly.
>

You still can get it:

pg_restore backup > backup.sql

will give you the SQL script.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com