[Spacewalk-list] OracleXE to Postgresql mig problem

[Milan Zázrivec]

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