Re: Looking to gather statistics on email received and sent

Sorry that was a terrible forum email I crafted.

What I am asking is: I like how the lookup can call sql right from the router config without needing to call a script to something which always opens up the can of worms requiring detainting.  If I use lookup I can use quote_pgsql, which I like.

Is there a config setting I could put it in after the route is completed successfully to log a stat using a lookup.

I have tried to rtfm but haven't yet found something obvious and thought the community could point me in the right direction.

Thanks

Ps, you don't need to design, only nudge.

-----Original Message-----
From: Jeremy Harris via Exim-users <[email protected]>
Sent: Wednesday, May 28, 2025 2:42 PM
To: [email protected]
Subject: [exim] Re: Looking to gather statistics on email received and sent

CAUTION: External to USask. Verify sender and use caution with links and attachments. Forward suspicious emails to [email protected]


On 2025/05/28 8:28 PM, Rowney, Dion via Exim-users wrote:
> I am working on rebuilding a mail server that handles lists.

Not enough detail.

> I moved all list data to postgres and it works great.
>
> Management is asking if its possible to use the postgres database to store list usage information.
>
> I was wondering if I could do this as part of the router.?

Short answer:   Yes:  Exim can do just about whatever you want; it's
a Simple Matter Of Programming.

Snide answer:   You want us to do your design work?  How much are
you paying?

--
Jeremy

--
## subscription configuration (requires account):
##   https://lists.exim.org/mailman3/postorius/lists/exim-users.lists.exim.org/
## unsubscribe (doesn't require an account):
##   [email protected]
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/

-- 
## subscription configuration (requires account):
##   https://lists.exim.org/mailman3/postorius/lists/exim-users.lists.exim.org/
## unsubscribe (doesn't require an account):
##   [email protected]
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/