[Spacewalk-list] Please help with Oracle to PostgreSQL migration

[Jan Pazdziora]

On Wed, Nov 30, 2011 at 11:53:53AM -0800, James Fillman wrote:
> 
> I've just gotten a chance to try and export the oracle db after applying the patch you provided. I was able to successfully output a full dump of the oracle database. Thanks!
> 
> I am, however, running into another problem. This time it's with the postgresql import. It bombs out with this error message:
> 
> ERROR:  invalid byte sequence for encoding "UTF8": 0xeda080
> HINT:  This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
> CONTEXT:  COPY rhnpackagechangelogdata, line 136452

Actually, I would kinda expect that patch

> diff --git a/utils/spacewalk-dump-schema b/utils/spacewalk-dump-schema index 0068ed4..b40593b 100755
> --- a/utils/spacewalk-dump-schema
> +++ b/utils/spacewalk-dump-schema
> @@ -118,8 +118,9 @@ sub process_table {
>  				} elsif ($types[$i] eq 'unknown' or $types[$i] eq 'BLOB') {	# blobs
>  					$row->[$i] =~ s!(.)! sprintf "\\\\%03o", ord($1) !seg;
>  				} else {
> +					utf8::encode($row->[$i]);
>  					$row->[$i] =~ s!([\x00-\x1f\x5c])! sprintf "\\x%02x", ord($1) !seg;
> -                                        utf8::encode($row->[$i]); utf8::decode($row->[$i]);
> +					utf8::decode($row->[$i]);
>  				}
>  				print $row->[$i];
>  			} else {

to address this issue.

What is on that line 136452?

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat