On Thu, 2004-06-10 at 22:01, Tom Collins wrote:
> Can anyone report on performance of the MySQL and/or Postgres
> backendsin 5.5.0 or later on a production machine? I made some
> significantchanges related to building SQL queries which should make
> them moresecure. I also fixed some outstanding bugs in Postgres code
> andconsolidated some code in MySQL and Postgres.
I have been using 5.5.0 in production for about a month with the
Postqresql back end. So far it has held up very well and have not had
any performance/stability problems.
I remember I had some problems in the beginning...but I didn't send them
to the list because previous messages regarding the use of the
Postgresql back end had went unanswered.
Looking through my notes....I had problems with --enable-pgsql-logging
--enable-pgsql-logging I remember, never created the appropriate
table(s). When I created the table(s) by hand, it still would not log
anything to it.
--enable-valias I can't remember exactly what the problem was here as I
didn't keep very good notes. I remember I had a problem with the 5.4.x
series as well, but I would receive a different error. I couldn't
create an alias that would be delivered to 2 different accounts. And I
remember in the 5.5.x series, if I tried to use valias with the -s
switch to look up an alias it would just print out the destination
address over and over again until I sent it a ctrl-c. I believe if it
didn't do that it would segfault.
Sorry I do not have more specifics for you.
My current configure line is:
/configure --enable-clear-passwd --enable-logging=p
--enable-learn-passwords --enable-qmail-ext --enable-auth-module=pgsql