Niblett, David A wrote: > Like many I want to upgrade to dbmail-2.2 from a 2.0 install. However I have > 37G DB and > really am worried about the time it's going to take to do the bytea > conversion on dbmail_messageblks.
Don't you have a spare machine to test this on? > I'd like to know if there is a way that I could dump the database, then > restore it so the new > tables created are in the bytea format. That's not the route used in the tested conversion script :-) > > I believe I can dump my database in about 2 hours and the restore takes about > as long. That's > with compression, so I can probably do it in less. I think it would be > easier for me to dump/restore > and hopefully get back up and running on my original dbmail-2.0 install. > Then I could wait for > another maintenance night and do the upgrade to 2.2. If you can get a 2.0 version with bytea support, your schema is compatible with both 2.2 and 2.0 daemons. Test the diff I sent you. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
