On Wednesday 08 January 2014 13:34:40 Željko Dokman wrote: > 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=#
Right. So you have no tables in your PG spaceschema. This explains the original error you showed in your initial posting. My recommendation is to: 1. first, uninstall spacewalk-setup-postgresql package from your Spacewalk installation 2. then go through the migration procedure again, starting with the part where you're supposed to run spacewalk-setup --db-only -MZ > -----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 _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
