[Spacewalk-list] OracleXE to Postgresql mig problem

[Željko Dokman]

Please can so body help me, my database knowledge is quite poor, so this error is a show stopper for my oracle>postgres migration

Best regards


-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Milan Zázrivec
Sent: Friday, January 03, 2014 5:03 PM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] OracleXE to Postgresql mig problem

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

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3741 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140107/31d2c71e/attachment.p7s>