Bug 1444375

Created attachment 1273247 [details]
5.4 5.5 migration diff

Description of problem:

There are differences in upgraded Oracle database schema to 5.8 Postgresql
compared to a new 5.8 installation

for example 5.4 Oracle migrated to 5.8 Postgresql schema diff:

Data in [rhnactiontype] for [root@DBNAME=ROOT] and [root@DBNAME=SCHEMA-5.4]
select label, name, trigger_snapshot, unlocked_only from rhnactiontype order by label, name, trigger_snapshot, unlocked_only
< clientcert.update_client_cert Update Client Certificate N Y

Data in [rhncontentsourcetype] for [root@DBNAME=ROOT] and [root@DBNAME=SCHEMA-5.4]
select label from rhncontentsourcetype order by label
< uln

Data in [rhncpuarch] for [root@DBNAME=ROOT] and [root@DBNAME=SCHEMA-5.4]
select label, name from rhncpuarch order by label, name
< aarch64 AArch64
< armv6hl ARMv6hl
> pSeries pSeries
< ppc64le ppc64le
< pSeries pSeries

Data in [rhnksinstalltype] for [root@DBNAME=ROOT] and [root@DBNAME=SCHEMA-5.4]
select label, name from rhnksinstalltype order by label, name
> fedora Fedora
< fedora18 Fedora

Data in [rhntaskoschedule] for [root@DBNAME=ROOT] and [root@DBNAME=SCHEMA-5.4]
select active_till, cron_expr, job_label, org_id from rhntaskoschedule order by active_till, cron_expr, job_label, org_id
<  0 * * * * ? errata-cache-default 
>  0 0/10 * * * ? errata-cache-default 

Data in [rhntimezone] for [root@DBNAME=ROOT] and [root@DBNAME=SCHEMA-5.4]
select display_name, olson_name from rhntimezone order by display_name, olson_name
< Chile (Continental) America/Santiago
< Chile (Easter Island) Pacific/Easter
< Korea Asia/Seoul
< Saudi Arabia Asia/Riyadh

Data in [view_rhnchannelarch] for [root@DBNAME=ROOT] and [root@DBNAME=SCHEMA-5.4]
select arch_label, label, name from view_rhnchannelarch order by arch_label, label, name
< rpm channel-aarch64 AArch64
> rpm channel-pSeries pSeries
< rpm channel-ppc64le PPC64LE
< rpm channel-pSeries pSeries

Data in [view_rhnchildchannelarchcompat] for [root@DBNAME=ROOT] and [root@DBNAME=SCHEMA-5.4]
select l1, l2 from view_rhnchildchannelarchcompat order by l1, l2
< channel-aarch64 channel-aarch64
< channel-arm channel-arm
< channel-armhfp channel-armhfp
> channel-pSeries channel-pSeries
< channel-ppc64le channel-ppc64le
< channel-pSeries channel-pSeries

Data in [view_rhnpackagearch] for [root@DBNAME=ROOT] and [root@DBNAME=SCHEMA-5.4]
select arch_label, label, name from view_rhnpackagearch order by arch_label, label, name
< rpm aarch64 AArch64
< rpm armv6hl ARMv6hl
< rpm ppc64le ppc64le

Data in [view_rhnpackagekey] for [root@DBNAME=ROOT] and [root@DBNAME=SCHEMA-5.4]
select key_id, name from view_rhnpackagekey order by key_id, name
< 11adc0948e1431d5 Fedora
< 24c6a8a7f4a80eb5 CentOS
< 2eb161fa246110c1 Fedora
< 32474cf834ec9cba Fedora
< 41605346066e5810 Spacewalk
< 636dea19a0a7badb Fedora
< 6a2faea2352c64e5 EPEL
< 72f97b74ec551f03 Oracle Inc.
< 73bde98381b46521 Fedora
< 89ad4e8795a43f54 Fedora
< b4bb871c873529b8 Fedora
< b8635eeb030d5aed Fedora
< d8d1fa8ca29cb19c Fedora
< dbeae2e4efe550f5 Fedora
< dcc981cdb8002de1 Spacewalk

Data in [view_rhnpuac] for [root@DBNAME=ROOT] and [root@DBNAME=SCHEMA-5.4]
select l1, l2 from view_rhnpuac order by l1, l2
< aarch64 aarch64
< aarch64 noarch
< armv6hl armv6hl
< armv6hl noarch
< noarch aarch64
< noarch armv6hl
< noarch ppc64le
< ppc64le noarch
< ppc64le ppc64le

Data in [view_rhnserverarch] for [root@DBNAME=ROOT] and [root@DBNAME=SCHEMA-5.4]
select arch_label, label, name from view_rhnserverarch order by arch_label, label, name
< rpm aarch64-redhat-linux aarch64
< rpm armv6hl-redhat-linux armv6hl
< rpm ppc64le-redhat-linux ppc64le

Data in [view_rhntaskoschedule] for [root@DBNAME=ROOT] and [root@DBNAME=SCHEMA-5.4]
select active_till, bunch, cron_expr, job_label, org_id from view_rhntaskoschedule order by active_till, bunch, cron_expr, job_label, org_id
<  errata-cache-bunch 0 * * * * ? errata-cache-default 
>  errata-cache-bunch 0 0/10 * * * ? errata-cache-default 

Data in [view_serverpackagearchcompat] for [root@DBNAME=ROOT] and [root@DBNAME=SCHEMA-5.4]
select package_arch, preference, server_arch from view_serverpackagearchcompat order by package_arch, preference, server_arch
< aarch64 0 aarch64-redhat-linux
< armv5tel 20 armv6hl-redhat-linux
< armv6hl 0 armv6hl-redhat-linux
< armv6hl 25 armv7l-redhat-linux
< armv6l 10 armv6hl-redhat-linux
< noarch 1000 aarch64-redhat-linux
< noarch 1000 armv6hl-redhat-linux
< noarch 1000 ppc64le-redhat-linux
< ppc64le 0 ppc64le-redhat-linux


5.6, 5.7 diffs attached

Version-Release number of selected component (if applicable):
rhn-upgrade-5.8.0.18-1.