On Wed, May 18, 2011 at 03:15:22PM +0200, Sascha Bendix wrote:
>
> I tried to migrate a spacewalk 1.4 installation from oracle-xe to PostgeSQL.
> After I got a valid dump out of spacewalk-dump-schema and the population of
> the database the psql-import stopped with the following error in the
> rhnactionconfigrevisionresult table:
>
> ERROR: invalid input syntax for type bytea
> CONTEXT: COPY rhnactionconfigrevisionresult, line 16, column result: "---
> /etc/sudoers2011-03-03 18:29:55.000000000 +0100
> +++ /tmp/.rhn-cfg-tmp-32305-1hfr7y2011-05-17 04:..."
>
> This is the first real entry in that table.
>
> This installation was upgraded from 1.1, so probably the schema doesn't work
> correctly.
>
> Is this a known issue? Does anyone knows a fix
Can you post the dump starting with the
-- Types for rhnactionconfigrevisionresult ...
line and ending with
\.
?
--
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
