I'm in the same boat Rod, but I'm also going to upgrade my postgres. Don't know if it much matters, but my plan is to stop mail services, do a dump of the database, alter the dump so the new table will be created with bytea, then do a restore. My calculations are that will take 4.5 hours total. At which time I can be back up and running then create the message caches and upgrade to 2.2 dbmail. For reference I have a 32G message store currently. -- David
________________________________
From: [EMAIL PROTECTED] on behalf of Rod K
Sent: Fri 12/8/2006 10:58 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] postgresql migrate 2.0 to 2.2
Paul J Stevens wrote:
Rod K wrote:
But I should still stop all services before running Step 4,
correct?
To be safe: yes. If you don't and still get away with it; let us know
:-)
LOL, I'm done being a guinea pig! Tests show that was only 4.5 hours (bytea
conversion I mean) and I can live with that. But dbmail-util -by took 12+ and
I can't leave with a total down time of over 18 hours so it's good to know I
can run that without shutting down, even if it has to be run twice.
Thanks for your help.
Rod
<<winmail.dat>>
