[Spacewalk-list] OracleXE to Postgresql mig problem

[Željko Dokman]

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?

 

Best regards

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140103/57a3d614/attachment.htm>
-------------- 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/20140103/57a3d614/attachment.p7s>