Le Tue, 22 May 2007 13:17:15 -0500, Kenneth Marshall <[EMAIL PROTECTED]> a écrit :
> 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 > Thanks Ken for you answer. But how can i do that ? There is an way to automate this process ? Pea
