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

[Jan Pazdziora]

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