[Spacewalk-list] OracleXE to Postgresql mig problem

[Daniel Souvignier]

Is it just this relation? If yes, try to create a new one from the psql 
interpreter. For that, login to psql with spaceuser and password of 
spaceuser and do a

CREATE TABLE log;

Mind the semicolon, it's important. After that, try importing the oracle 
dump again.

Regards,
Daniel

Am
  07.01.2014 09:53, schrieb Z(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 Z(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
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list


-- 
----------------------------------------------------------------
Daniel Souvignier
Fachinformatiker Systemintegration in Ausbildung
Lehrstuhl für integrierte Analogschaltungen
RWTH Aachen
Sommerfeldstraße 24 (Walther-Schottky-Haus)
52074 Aachen
Raum 24C 313
Tel.:0241/80-27771
www.ias.rwth-aachen.de

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140107/b74b0846/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4302 bytes
Desc: S/MIME Kryptografische Unterschrift
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140107/b74b0846/attachment.p7s>