1 Topic by annybon24 (edited by annybon24 2021-06-17 20:43:10)

  • annybon24
  • Member
  • Offline
  • Registered: 2021-06-17
  • Posts: 1

Topic: PostgreSQL trigger when email received

Version - 1.4.0
OS: Ubuntu 18.04
Backend: PGSQL
Web Server: Nginx
iRedMail Pro: No

Where the received email records are being saved in the PostgreSQL databases? There are 7 databased created automatically, i.e. amavisd, fail2ban, iredadmin, iredapd, postgres, roundcubemail, vmail. How can I execute a PSQL trigger when any user gets an email. Also, how can I get the sender email, subject, receiver email, id/path of the email file that is being saved in ubuntu dir & etc. data from that trigger?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,787

Re: PostgreSQL trigger when email received

FYI: https://doc.dovecot.org/configuration_m … ification/