I removed and installed again spacewalk-setup-postgresql package, and repeated steps... ....but unfortunate the same error recurs
[root@skynet ~]# spacewalk-setup --db-only ** Database: Setting up database connection for PostgreSQL backend. Database "rhnschema" already exists The embedded database appears to be already installed. Either rerun this script with the --skip-db-install option, or use the '/usr/bin/spacewalk-setup-postgresql remove --db rhnschema --user rhnuser' script to remove the embedded database and try again. [root@skynet ~]# /usr/bin/spacewalk-setup-postgresql remove --db rhnschema --user rhnuser [root@skynet ~]# spacewalk-setup --db-only ** Database: Setting up database connection for PostgreSQL backend. Database "rhnschema" does not exist ** Database: Installing the database: ** Database: This is a long process that is logged in: ** Database: /var/log/rhn/install_db.log *** Progress: # ** Database: Installation complete. ** Database: Populating database. *** Progress: #################################### [root@skynet ~]# PGPASSWORD=spacewalk psql -a -U spaceuser spaceschema psql (8.4.18) Type "help" for help. spaceschema=# \d No relations found. spaceschema=# \d log Did not find any relation named "log". spaceschema=# \q [root@skynet tmp]# PGPASSWORD=spacewalk psql -h localhost -U spaceuser spaceschema < spacewalk-oracle.dump UPDATE 0 ERROR: relation "log" does not exist Best regards -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Milan Zázrivec Sent: Wednesday, January 08, 2014 2:58 PM To: [email protected] Subject: Re: [Spacewalk-list] FW: OracleXE to Postgresql mig problem 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
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
