Re: UDD postgresql dump
On 15/12/12 at 23:02 +0100, Tomasz Muras wrote:
> On 12/15/2012 10:46 PM, gregor herrmann wrote:
> >On Sat, 15 Dec 2012 22:01:19 +0100, Tomasz Muras wrote:
> >
> >>I've downloaded the dump of UDD from [1] and I'm trying to restore
> >>is on postgresql-9.1, however I get tons of errors (see below).
> >
> >Guess: you need to install postgresql-9.1-debversion before.
>
> That's it, thanks Greg.
>
> The only error I have left is:
> psql:udd.sql:9954333: ERROR: invalid byte sequence for encoding
> "UTF8": 0xf66c6ce4
> CONTEXT: COPY upstream, line 14757
> psql:udd.sql:9972739: ERROR: invalid byte sequence for encoding
> "UTF8": 0xf66c6ce4
> CONTEXT: COPY upstream_status, line 8680
> SET
>
> I presume that the DB dump is in utf-8 format - bur there may be
> something wrong with the strings there.
Have you tried following the instructions on
http://udd.debian.org/hacking.html ?
Lucas
Reply to: