[Spacewalk-list] spacewalk-dobby problem

[Jan Pazdziora]

On Fri, May 25, 2012 at 03:28:51PM +0200, stefano ciavarella wrote:
> when i try to import the oracle's dump :
> 
> PGPASSWORD=spacepw psql -h localhost -U spaceuser spaceschema <
> /var/spacewalk/spacewalk-oracle.dump
>  setval
> --------
>   10926
> (1 row)
> 
>  setval
> --------
>       1
> (1 row)
> 
>  setval
> --------
>       1
> (1 row)
> 
>  setval
> --------
>       1
> (1 row)
> 
>  setval
> --------
>       1
> (1 row)
> 
>  setval
> --------
>       1
> (1 row)
> 
> ERROR:  relation "rhn_appinst_instance_id_seq" does not exist
> LINE 1: select pg_catalog.setval('rhn_appinst_instance_id_seq', 1, f...
>                                  ^

This means your current database schema is <= 1.6 while the new one
that you have in PostgreSQL is 1.7. As noted in

	https://fedorahosted.org/spacewalk/wiki/PostgreSQLFromOracle

	Therefore, you need the PostgreSQL schema to be of the same
	version as the one in Oracle. In other words, you need to
	upgrade the Spacewalk and the Oracle schema to the latest
	version, to match the schema that you will likely have in
	PostgreSQL.

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