Description of problem: Script satellite-upgrade-estimates says "Upgrade of Red Hat Satellite database should take at least: 00:00" on a very big DB (/var/lib/pgsql/data is 38GB) Version-Release number of selected component (if applicable): rhn-upgrade-5.7.0.22-1.el6sat.noarch How reproducible: 1 of 1 Steps to Reproduce: 1. Have Satellite 5.6.0@RHEL6@EmbeddedPostgreSQL and attempt to upgrade to 5.7.0@RHEL6@EmbeddedPostgreSQL (no OS upgrade) 2. # /etc/sysconfig/rhn/satellite-upgrade/scripts/satellite-upgrade-estimates Actual results: # /etc/sysconfig/rhn/satellite-upgrade/scripts/satellite-upgrade-estimates Will you be installing Red Hat Satellite 5.7 on a different system and migrating to it? [N] N Computing ... satellite-upgrade-postgresql.txt, point 1: * Command line part of Red Hat Satellite upgrade should take approximately: 00:45 (HH:MM) satellite-upgrade-postgresql.txt, point 2: * Upgrade of Red Hat Satellite database should take at least: 00:00 (HH:MM) * Minimum free disk space required for schema upgrade is 1000 MB Expected results: I would expect some bigger number in "Upgrade of Red Hat Satellite database should take at least" and maybe in "Minimum free disk space required for schema upgrade" as well. Additional info: # du -hs /var/lib/pgsql/data/ 38G /var/lib/pgsql/data/ # db-control tablesizes | grep -v -e ' bytes' -e ' kB' Tables Planner Size Real Size Real Size+Toasts+Idx qrtz_fired_triggers 10 MB 11 MB 79 MB qrtz_triggers 26 MB 26 MB 58 MB rhnaction 278 MB 278 MB 375 MB rhnactionerrataupdate 76 MB 76 MB 125 MB rhnchannelnewestpackage 52 MB 52 MB 127 MB rhnchannelpackage 32 MB 32 MB 64 MB rhnchecksum 1773 MB 1773 MB 3491 MB rhnerrata 62 MB 62 MB 82 MB rhnerratabuglist 23 MB 23 MB 27 MB rhnerratafile 198 MB 198 MB 436 MB rhnerratafilechannel 113 MB 113 MB 231 MB rhnerratafilepackage 16 MB 16 MB 31 MB rhnerratanotificationqueue 37 MB 37 MB 74 MB rhnerratapackage 18 MB 18 MB 29 MB rhnpackage 87 MB 87 MB 99 MB rhnpackagecapability 5926 MB 5926 MB 10101 MB rhnpackagechangelogdata 92 MB 92 MB 135 MB rhnpackagechangelogrec 1196 MB 1196 MB 2434 MB rhnpackageevr 11 MB 11 MB 18 MB rhnpackagefile 7577 MB 7577 MB 10 GB rhnpackagenevra 21 MB 21 MB 37 MB rhnpackageprovides 514 MB 514 MB 1068 MB rhnpackagerepodata 182 MB 182 MB 2134 MB rhnpackagerequires 203 MB 203 MB 356 MB rhnprivatechannelfamily 13 MB 13 MB 18 MB rhnserver_log 24 MB 24 MB 26 MB rhnserveraction 138 MB 138 MB 207 MB rhnserverneededcache 1047 MB 1047 MB 4392 MB rhnserverpackage 112 MB 114 MB 211 MB rhnsnapshot 17 MB 17 MB 18 MB rhnsnapshotpackage 181 MB 184 MB 353 MB rhntaskorun 41 MB 41 MB 46 MB rhnvisibleobjects 106 MB 106 MB 193 MB test 59 MB 60 MB 60 MB
From upgrade instructions: 4. Get the upgrade estimates. This step applies if you're migrating from Oracle to PostgreSQL database. Please run the following script from rhn-upgrade package as root: /etc/sysconfig/rhn/satellite-upgrade/scripts/satellite-upgrade-estimates th DB is obviously PostgreSQL -> notabug