[Spacewalk-list] OracleXE to Postgresql mig problem

[Milan Zázrivec]

On Friday 03 January 2014 15:55:01 Željko Dokman wrote:
> Hi all
> 
> 
> 
> I need some help with migrating my spacewalk backend DB from Oracle XE to
> PostgreSQL.
> 
> 
> 
> I am following instructions from
> 
> https://fedorahosted.org/spacewalk/wiki/PostgreSQLFromOracle
> 
> 
> 
> And everything was going OK until the point where Oracle dump is to be
> imported in to postgresql.
> 
> 
> 
> [root at skynet ~]# PGPASSWORD=******* psql -h localhost -U spaceuser
> spaceschema < /tmp/spacewalk-oracle.dump
> 
> UPDATE 0
> 
> ERROR:  relation "log" does not exist
> 
> Can anyone help me to resolve this problem?

Has your PostgreSQL schema been properly populated?

Do your Oracle and PostgreSQL schema versions match?

-MZ