One more appeal for help before abandoning migration plan Best regards
-----Original Message----- From: Željko Dokman Sent: Tuesday, January 07, 2014 12:19 PM To: [email protected] Subject: RE: [Spacewalk-list] OracleXE to Postgresql mig problem Spacewalk versions match, and the log populate_db.log is attached, I don’t see any errors in the log [root@skynet rhn]# rpm -q spacewalk-schema spacewalk-schema-2.0.2-1.el5 [root@skynet rhn]# rhn-schema-version 2.0.2-1.el5 Best regards -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Milan Zázrivec Sent: Tuesday, January 07, 2014 11:39 AM To: [email protected] 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 [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
populate_db.rar
Description: Binary data
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
