[Spacewalk-list] FW: OracleXE to Postgresql mig problem

[Milan Zázrivec]

On Wednesday 08 January 2014 13:34:40 Željko Dokman wrote:
> Here is the output..
> 
> [root at 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: spacewalk-list-bounces at redhat.com
> [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Milan Zázrivec
> Sent: Wednesday, January 08, 2014 1:59 PM
> To: spacewalk-list at redhat.com
> 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: spacewalk-list at redhat.com
> > 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 at skynet rhn]# rpm -q spacewalk-schema
> > spacewalk-schema-2.0.2-1.el5
> > [root at skynet rhn]# rhn-schema-version
> > 2.0.2-1.el5
> > 
> > Best regards
> > 
> > 
> > -----Original Message-----
> > From: spacewalk-list-bounces at redhat.com
> > [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Milan Zázrivec
> > Sent: Tuesday, January 07, 2014 11:39 AM
> > To: spacewalk-list at redhat.com
> > 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
> > Spacewalk-list at redhat.com
> > https://www.redhat.com/mailman/listinfo/spacewalk-list
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list