I always thought that messages were split into blocks for MySQL, anyway,
bytea fields in PGSQL can support upto 1GB of data.
Paul J Stevens wrote:
That's just for historical reasons.
READ_BLOCK_SIZE is defined in db.h as 512KB, but you can set it to 512MB
or even bigger. Mysql supports 4GB for
Paul J Stevens wrote:
Matthew O'Connor wrote:
I took a quick look at the wiki and didn't see any clear documentation
of the timeout options in dbmail.conf, can you explain them further? Or
point in towards the M so that I can RTFM?
man dbmail.conf
but that's a bit too terse.
Paul J Stevens wrote:
Jorge Bastos wrote:
Hi,
Guys, I'm having complains about timeouts with outlook 2003.
i have about 40/50 connections, mixed IMAP and POP3 (80% POP3, 20% IMAP)
at the same time in the work time.
Maybe this is some need of a fine tunning to dbmail.conf, any sugestion?
If it'
Michael Monnerie wrote:
(this mail is easier to read with a fixed charset)
Hi, I have a question to the SQL gurus on this list. I've extended the
domains table to resolve the n:m relation customer <-> domaingroups:
CREATE TABLE zmi_domains (
domain_idnr BIGSERIAL UNIQUE, --
Michael Monnerie wrote:
On Samstag, 16. Dezember 2006 14:52 Leonel Nunez wrote:
http://www.postgresql.org/docs/8.2/interactive/datatype-binary.html
Thank you, found it already - I was looking at strings.
Back to the topic:
Although I prefer when software "just works", but wouldn't we possibly
Larry Rosenman wrote:
On Fri, 15 Dec 2006, Matthew O'Connor wrote:
Right, but the test program (as best I can tell) calls char2date_str
with a date string created by a call to the OS which will most likely
give us a sane representation. I think the problem is that gmime (or
what ever
Paul J Stevens wrote:
Matthew O'Connor wrote:
I think that is a rather drastic statement and not what I understood.
There are problems when a message has a header that is UTF8 encoded, but
I believe that is against the spec isn't it?
Yep. Headervalues are /supposed/ to be us-ascii
n. The two test programs I
wrote trace back from char2date_str which is present in that function.
Since it didn't fail, I'm at a loss right now to understand what's broken.
Aaron
On Fri, Dec 15, 2006, Matthew O'Connor said:
Sorry if I'm stating the obvious here, but the
Sorry if I'm stating the obvious here, but the problem is that PG
doesn't accept "1166132546-05-07 15:42:45" as a valid timestamp because
it isn't. The question is, where did that malformed year come from?
This sounds like DBMail (or gmime) isn't interpreting the date value
correctly from the
Aaron Stone wrote:
On Fri, 2006-12-15 at 12:11 +0200, VladK wrote:
Hi All.
I'm using dbmail-2.2.1; libsieve-2.2.1.
On the delivery stage I have got such error:
[snip]
OR", 0.01000, content="FrontPage+Editor, 0.01000')] : [ERROR: invalid
byte sequence for encoding "UTF8": 0xb5 ]
Dec 15 05:00
Larry Rosenman wrote:
Matthew O'Connor wrote:
I running PG 8.1 with a UTF-8 encoded DB, it was painful during the
2.1 dev tree, but at this point everything works. Every once in
while I'll get a message that fails to deliver because of an invalid
UTF sequence, but that's very ra
Michael Monnerie wrote:
On Freitag, 15. Dezember 2006 09:22 Paul J Stevens wrote:
Presently, dbmail is highly US-ASCII centric. One of the goals for
2.4 is to make it more UTF-8 oriented.
Uhm, does that mean I'm going to have problems with my postgresql
database created with encoding=UTF-8 ?
Alexander Benaguev wrote:
it was a topic in list about separating insert/select queries between
master/slaves. if anybody interested yet, check this
http://sqlrelay.sourceforge.net/sqlrelay/router.html and share your
opinion, please.
I have no idea how good of a product that is, however in gene
Michael Monnerie wrote:
My question is, what is the biggest installation of dbmail in terms of
number of users, emails, or size in GB?
I just found this, and it looks good:
http://mailman.fastxs.net/pipermail/dbmail/2004-December/005878.html
I have no idea what the biggest install out there i
Leander Koornneef wrote:
I partly agree with you, apart from your statement being mostly
flamebait :-)
However, riddle me this if you will:
What is the current (reasonable|viable|possible) alternative in
accomplishiing
true high availabilty and/or clustering when using open source databases
Lars Kneschke wrote:
Justin McAleer <[EMAIL PROTECTED]> schrieb:
Mysql: 95 seconds to deliver all 1000 messages. Both cores
on the DB server were effectively peaked during delivery.
Postgres: 10 seconds to deliver all 1000 messages. DBMail
was really close to being able to deliver as fast as
po
First let me say that I am clearly in the PG camp and my
comments might be colored in that direction.
Tom Allison wrote:
I'm trying to find out what real experiences people have with using
mysql and postgresql. I have to warn any responders that I am very big
on having database that behave t
Aaron Stone wrote:
On Fri, Dec 1, 2006, Matthew O'Connor said:
Totally non-scientific and based on my memory, after I got the process
down (I scripted everything on a test server), it took me maybe about 2
hours for about 6G of data on an 64 with a decent SATA drive, using
PostgreSQ
Totally non-scientific and based on my memory, after I got the process
down (I scripted everything on a test server), it took me maybe about 2
hours for about 6G of data on an 64 with a decent SATA drive, using
PostgreSQL 8.1. It was a lot slower, but just before 2.2 was release
Paul made a si
I Pauls point is that the code in libdbmail would be well written and
scrutinized by many people, so it would be at least as efficient as
anything else. The extra layer in between might add some inefficiency,
but you could make that same argument for everything in software, might
it not be mo
That is clearly a Postfix error. The problem is that you have a lookup
table defined in your postfix config, perhaps for aliases or something,
and Postfix doesn't have MySQL support installed. This happened to me
(with pgsql support) not long ago when Yum updated my Postfix automatically.
Ma
Scott Everson wrote:
How long have you been running DBMail?
2 years or so...
What is your MTA of choice?
Postfix, did I mention Postfix?
How many mailboxes are you hosting in DBMail?
About 100 users with mostly small mailboxes with a few mega-users with
approx 2gig of email under their
It might be a good idea to document the current schema including FKs and
recommeded indexes to the wiki or somewhere.
[EMAIL PROTECTED] wrote:
Hi,
For situations like this one, for who update via SVN, that Paul and Aaron to
add that information to the Changelog file.
I have a similar situat
23 matches
Mail list logo