This is a known issue, but the docs don’t cover the necessary step to avoid it. We’ll need to get that fixed.
The issue is that when I original built the Debian/Ubuntu version of the install, I didn’t realize that apt-get had this (really scary) feature. auto-remove gives me nightmares, but it’s a reality we have to live with. So, I changed the install.sh to explicitly request all of the dependencies be installed, and vrtualmin-base no longer depends on anything (except some of our Virtualmin packages). This solves the problem for future installs, but makes an additional step for those upgrading, if they have auto-remove enabled (which is, frighteningly, the default).
So, the solution is to explicitly install all of those dependencies using apt-get before upgrading the virtualmin-base package, so that the packages get a flag that says you wanted those packages explicitly, rather than installing them to resolve dependencies.
I’ll ask Eric to try this out and make sure I’m remembering correctly, and to get the docs updated for this upgrade. (The Debian 5 to 6 upgrade docs also ought to have this step, but I don’t recall if they do.)
Okay, that can all be corrected by running this command… this will set all these packages as “manually installed”, which will prevent them from showing up in the “autoremove” list:
After applying Eric’s command, installing virtualmin-base still suggests removing postgresql-8.4 and postgresql-client-8.4. But I did see a notification during upgrade that postgresql 8.4 was obsolete and should be removed. So should those to packages be added to the list and then purged afterwards?
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Cfg-files/Unpacked/Failed-cfg/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Description
+++-================-================-================================================
ii postgresql 8.4.13-0ubuntu10 object-relational SQL database (supported versio
un postgresql-7.4 <none> (no description available)
un postgresql-8.0 <none> (no description available)
ii postgresql-8.4 8.4.13-0ubuntu10 object-relational SQL database, version 8.4 serv
un postgresql-clien <none> (no description available)
ii postgresql-clien 8.4.13-0ubuntu10 front-end programs for PostgreSQL 8.4
ii postgresql-clien 106ubuntu1 manager for multiple PostgreSQL client versions
ii postgresql-commo 106ubuntu1 PostgreSQL database-cluster manager
un postgresql-doc-8 <none> (no description available)
un postgresql-pl <none> (no description available)
Notification seen during upgrade (extracted form /var/log/dist-upgrade/apt-term.log).
[code]Obsolete major version 8.4
The PostgreSQL version 8.4 is obsolete, but the server or client packages are still installed. Please install the latest packages (postgresql-9.1 and postgresql-client-9.1) and upgrade the existing clusters with pg_upgradecluster (see manpage).
Please be aware that the installation of postgresql-9.1 will automatically create a default cluster 9.1/main. If you want to upgrade the 8.4/main cluster, you need to remove the already existing 9.1 cluster (pg_dropcluster --stop 9.1 main, see manpage for details).
The old server and client packages are no longer supported. After the existing clusters are upgraded, the postgresql-8.4 and postgresql-client-8.4 packages should be removed. Please see /usr/share/doc/postgresql-common/README.Debian.gz for details.
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Description
+++-================-================-================================================
ii postgresql 9.1+129 object-relational SQL database (supported versio
un postgresql-7.4 <none> (no description available)
un postgresql-8.0 <none> (no description available)
ii postgresql-8.4 8.4.13-0ubuntu10 object-relational SQL database, version 8.4 serv
ii postgresql-9.1 9.1.5-0ubuntu12. object-relational SQL database, version 9.1 serv
un postgresql-clien <none> (no description available)
ii postgresql-clien 8.4.13-0ubuntu10 front-end programs for PostgreSQL 8.4
ii postgresql-clien 9.1.5-0ubuntu12. front-end programs for PostgreSQL 9.1
ii postgresql-clien 129 manager for multiple PostgreSQL client versions
ii postgresql-commo 129 PostgreSQL database-cluster manager
un postgresql-contr <none> (no description available)
un postgresql-doc-8 <none> (no description available)
un postgresql-doc-9 <none> (no description available)
un postgresql-pl <none> (no description available)
un postgresql-plpyt <none> (no description available)
postgresql-8.4 was installed when I ran Virtualmin gpl install.sh on Ubuntu server 10.04.x LTS, so shouldn’t the upgrade to 12.04.1 LTS have automatically handled the transition from postgresql-8.4 to 9.1?
Besides, I don’t use postgresql and the postgresql module shows that the default databases have no tables, so I assume that it’s not used by the system, Virtualmin or Webmin and is safe just to purge 8.4?