Re: UDD postgresql dump

[Tomasz Muras <nexor1984@gmail.com>]

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.

cheers,
Tomek