I do have a spare machine to try it on, but given my smaller test and reports of others with similar sized DB's it will potentially take many hours.
My plan was to actually set it up on a different machine and start DBMail on that, if it works, then away I go. If it doesn't I go back to the current database. I also want to go to 8.1.8 of postgres, etc, etc. So rather than have one giant outage that may screw up, I was going to try and go with a few smaller. I have to dump the DB and restore anyways, so if I could do that and get bytea going that would be a timesaver. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville Regional Utilities | Web: http://www.gru.net/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul J Stevens Sent: Friday, February 23, 2007 5:17 PM To: DBMail mailinglist Subject: Re: [Dbmail] Dreaded TEXT to BYTEA conversion (2.0 -> 2.2) 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 _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
