Обсуждение: upgrading from debian 6 to 7--do in place or wipe-and-install?
We're looking at upgrading our database hosts running postgres 9.2 from debian 6/squeeze to debian 7/wheezy. It seems to me that using apt to upgrade in-place would be less work than wiping the boxes and reinstalling debian 7 from scratch, but the latter way would be cleaner.
Does anybody have any experience with upgrading in-place? Are there any recommendations for one or the other?
On Fri, 28 Mar 2014 10:35:20 -0700 Kevin Goess <kgoess@bepress.com> wrote: > > Does anybody have any experience with upgrading in-place? Are there any > recommendations for one or the other? It works well if you pg_dumpall, remove postgres, upgrade debian, then reinstall postgres and restore from dumpall. Remember to do 'upgrade-grub' before rebooting, so that the new kernel's parameters are loaded (if you use grub2) I followed the instructions on this page : http://www.howtoforge.com/how-to-upgrade-debian-squeeze-to-wheezy Below are the notes I took while upgrading my server. I use a LAMP stack made of postgresql, apache and mod_perl. # #upgrade server to new debian stable (Squeeze -> Wheezy) # #dump the dbs cd /tmp su postgres pg_dumpall > 8.4.out #remove old pg apt-get purge postgresql-8.4 postgresql-client-8.4 postgresql-plperl-8.4 #mettre à jour apt-get update apt-get upgrade apt-get dist-upgrade #no packages must be on hold dpkg --audit dpkg --get-selections | grep hold # Press g and the list shows which packages need your attention. Fix any packages in the action list, until the message says: # No packages are scheduled to be installed, removed or upgraded # Only then you are done and ready to pass this point. aptitude #edit /etc/apt/sources.list sed -i 's/squeeze/wheezy/g' /etc/apt/sources.list #using this one now deb http://ftp.fr.debian.org/debian/ wheezy main contrib non-free #instructions : http://www.debian.org/security/ deb http://security.debian.org/ wheezy/updates main contrib non-free #launch actual upgrade apt-get update apt-get upgrade apt-get dist-upgrade #restore conf files logrotate.d/apache apache2.conf #reinstall perl modules cpan Apache::DBI DBD::Pg Apache::Session Apache::Session::Postgres Apache2::Request Apache2::RequestIO Apache2::RequestRecApache2::SubRequest Apache2::Response Apache2::Filter Apache2::Cookie Apache2::Connection APR::Table CGI::CookieURI::Escape DBD::SQLite #upgrade postgres apt-get install postgresql postgresql-client postgresql-plperl-9.1 postgresql-doc #comment ssl=true in /etc/postgresql/9.1/main/apache2.conf #edit pg_hba.conf #local all all peer local all all trust #vérifier que ça tourne psql -V #restore from dumpall psql -f 8.4.out postgres #run update-grub #reboot -- Regards, Vincent Veyron http://libremen.com/ Legal case, contract and insurance claim management software