[Spacewalk-list] OracleXE to Postgresql mig problem

[Željko Dokman]

Spacewalk versions match, and the log  populate_db.log is attached, I don’t see any errors in the log

[root at skynet rhn]# rpm -q spacewalk-schema
spacewalk-schema-2.0.2-1.el5
[root at skynet rhn]# rhn-schema-version
2.0.2-1.el5

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: Tuesday, January 07, 2014 11:39 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] OracleXE to Postgresql mig problem

On Tuesday 07 January 2014 10:13:01 Željko Dokman wrote:
> I got this error..
> 
> 
> 
> spaceschema=# create table log;
> 
> ERROR:  syntax error at or near ";"
> 
> LINE 1: create table log;

You should not be creating any tables manually. Not when you're following the process described at the page you referenced earlier.

Here's how the Ora->Pg migration process works:
1. you have a Spacewalk version x, using Oracle DB backend 2. you create a DB dump from your Oracle DB in a format consumable by PostgreSQL database 3. you install a PostgreSQL database server 4. you install the database schema to your PostgreSQL database (that spacewalk-setup --db-only step). Here the schema version installed in your Oracle DB and the schema version you just installed into your PG database have to match. What's the schema version in your Oracle DB? Run:

    $ rhn-schema-version

What's the version you just installed into your PG database? Presumably, it's:

   $ rpm -q spacewalk-schema

The final step is to load the dump you created in step two into your PG schema. Here the process for you fails, b/c the table 'log' in your PG schema does not exist (but it does exist in your Oracle schema).

This may indicate that:
1. for some reason, the schema you just installed into your PG does not match your Oracle schema (not sure how this could have happened though) 2. there was a problem populating your PG schema and the log table (or perhaps other tables too) were not properly created. For this, you should check the following file for errors:

    /var/log/rhn/populate_db.log

Regards
-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: populate_db.rar
Type: application/octet-stream
Size: 1573 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140107/4886da4a/attachment.obj>
-------------- 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/4886da4a/attachment.p7s>