Patch for Postgres (against postfix-19990906-pl05) (fwd)

Marc G. Fournier                                 marc.fournier@acadiau.ca
Senior Systems Administrator                            Acadia University

  "These are my opinions, which are not necessarily shared by my employer"

---------- Forwarded message ----------
Date: Thu, 07 Oct 1999 22:12:03 +1000
From: Greg Wickham <gjw@deakin.edu.au>
To: postfix-testers@postfix.org
Subject: Patch for Postgres (against postfix-19990906-pl05)


Hi,

I submit for approval and acceptance the following patch
for postfix-19990906-pl05 to use postgres for map lookups.

Not sure if this is the correct mailing list for this submission.
Hopefully will be ok.

Patch is available from:

http://www.deakin.edu.au/~gjw/postfix/postfix-postgres.patch

Comments appreciated. I based this patch on the mysql patch
which was in pl02. This patch uses a different connection
algorithm in that a connection to a database isn't made until
the first lookup. Also, only a single connnection is ever
maintained. If the connection goes bad then the next database
is tried. If all databases return errors then the query returns
an error.

I have had a minor (understatement?) problem with 'myrealloc'.
And had to code around using this function. Not sure what the
heck is going on because there is only about a dozen or so
lines of code before the problem arose.

I've tested this patch and I've had good success with it.
Although stress testing at high load would be desireable.

cheers,

   -Greg

------------------------------------------------------------------
wheNufiNdu'RselFindAngeRwheNu'rThreAtenEdbyAstrAngeRwheNitlOoksLik