Dreaded TEXT to BYTEA conversion (2.0 -> 2.2)

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.
 
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.
 
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.
 
I assume I would have to change the SQL queries in 2.0 to
deal with the bytea to text conversion
but I don't see that being a big deal, maybe I'm wrong.
 
Anyone have any thoughts about this?  Would I need to make
changes to the dbmail program
if I used bytea in 2.0?
 
Thanks,
David
 
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Niblett, David A wrote:
> Anyone have any thoughts about this?  Would I need to
make changes to the dbmail program
> if I used bytea in 2.0?

That patch was done fairly early on after branching 2.0.
It's in the svn
tree of course but only as part of a larger chunk of
changes. Let's
see... This particular change was checked in by me nov 11
2005 into my
git tree.

The attached diff should cover that contingency. No
warrenties of course.


-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

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
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

this time without colorized output

-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail