Hi,

Paul J Stevens wrote:

Perhaps you should then first migrate from pgsql to mysql, before moving from 1.2 to 2.0:

I once used:

pg_dump --file=/var/tmp/dbmail-dump.pgdata --format=p --data-only --inserts --no-owner --no-reconnect --no-privileges dbmail
mysql -f dbmail < /var/tmp/dbmail-dump.pgdata
Seems to be a very useful approach. I guess the slowness is not an issue if you only have to do it one.

which is very slow, but should work in most circumstances (exotic charsets are always a pain).

Also, I'm working on a sql-only solution to be included in the debian packages. I don't want to make the dbmail packages depend on python, python-mysql, and python-pgsql just to convert if I can avoid it. Also, I want the conversion to be non-interactive, and in-place, that is without resorting to different databases for dbmail1 and dbmail2.
I agree that an SQL-only solution is much better. If you're working on such a solution, please update me on your progress. Have you seen Christian Warden's earlier update script?

Ilja
--
IC&S
Stadhouderslaan 57
3583 JD Utrecht

PGP-key:
http://www.ic-s.nl/keys/ilja.txt

Reply via email to