Here is the output.. [root@skynet ~]# PGPASSWORD=******* psql -a -U spaceuser spaceschema psql (8.4.18) Type "help" for help.
spaceschema=# \d log Did not find any relation named "log". spaceschema=# \d No relations found. spaceschema=# Best regards -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Milan Zázrivec Sent: Wednesday, January 08, 2014 1:59 PM To: [email protected] Subject: Re: [Spacewalk-list] FW: OracleXE to Postgresql mig problem On Wednesday 08 January 2014 12:09:56 Željko Dokman wrote: > One more appeal for help before abandoning migration plan When you connect to your PG database with psql, do you see the 'log' table created? spaceschema=# \d log or what tables do you see created in your PG schema? spaceschema=# \d -MZ > -----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 _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
