[Spacewalk-list] Unable to import spacewalk-dump-schema to psql

[Sascha Bendix]

Hi,

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

Regards,

Sascha

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.