Looking to gather statistics on email received and sent

"Rowney, Dion via Exim-users" <[email protected]>
Newsgroups gmane.mail.exim.user
Message-ID <YQBPR0101MB40338394A1ED308608AFDBAE9367A@YQBPR0101MB4033.CANPRD01.PROD.OUTLOOK.COM>
I am working on rebuilding a mail server that handles lists.

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.?   Maybe something like:

Some_config = ${lookup pgsql \
      {INSERT INTO listman.stats \
        VALUES \
         ('${quote_pgsql:$local_part}'}
 } 

Or something similar, or am I crazy?  

Thoughts?

Thanks in advance.


-- 
## 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/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.