El 11/10/2010 20:18, Jesse Norell escribió:
>
>> But i just install the new server today and, at this moment, only 50% of
>> users have the mailbox migrated. I continue with mailbox2dbmail :(
>
>    Database tuning has a huge impact on dbmail performance, too, so make
> sure you're not running with default memory settings and such.

Yes, i only do a small database optimization. I need to work on it.

>
>
>> Another side effect is that the messages are marked as 'unread'.
>>
>> How can i mark it as 'readed'?
>
>    For pop3 there is a status field on the messages, I believe status=1
> is "read" but not deleted; imap uses flags, and I'm not as familiar with
> those, you might set seen_flag and unset recent_flag for the message.
>

When a message is readed the postgres log shows:

UPDATE dbmail_messages SET recent_flag=0, seen_flag=1 where 
message_idnr = 466779 AND status < 2 AND mailbox_idnr = 157

I will try to make a script that do it with readed messages.

Thanks.

-- 
Oswaldo Hernández
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to