On Tue, May 22, 2007 at 06:22:21PM +0200, Pea wrote: > Hello, > > It is possible to switch dspam backend from mysql to postgresql. I've a > huge database (~ 20Go) and for some reasons i want to have postgresql > backend. A dump from mysql to postgresql doesn't work... > Any ideas ? > > Thank > Yes, it is possible. You need to use the BIGINT token table definition for the PostgreSQL database and adjust the 64-bit hash from the unsigned usage in MySQL to the signed usage of PostgreSQL by subtracting 9223372036854775808 (2**63) from the MySQL export before importing it into PostgreSQL.
Ken
