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

[Željko Dokman]

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=#


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: 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3741 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140108/df50772c/attachment.p7s>