1 Topic by ebo

  • ebo
  • Member
  • Offline
  • Registered: 2021-09-06
  • Posts: 5

Topic: Last login with postgresql

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 2021062401
- Deployed with iRedMail Easy or the downloadable installer?: iRedMail Easy
- Linux/BSD distribution name and version: Ubuntu 20.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PSQL
- Web server (Apache or Nginx): nginx
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Is support for last login (pop3/imap) for PSQL backend in the pipeline or will it need to wait for dovecot to support it?

It looks possible via wrapping a script, but not sure how good that would work.

----

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

2 Reply by Cthulhu

  • Cthulhu
  • Member
  • Offline
  • Registered: 2019-06-04
  • Posts: 907

Re: Last login with postgresql

isn't the backend irrelevant? its just information storage, its all about the dovecot plugin

3 Reply by ebo

  • ebo
  • Member
  • Offline
  • Registered: 2021-09-06
  • Posts: 5

Re: Last login with postgresql

I believe so.
Easy deployment deploy with DB settings. but after some googling it looks like that plugin doesnt support PSQL backend.
But i believe there is other ways of populating the database then this plugin..

Info about no psql support: https://docs.iredmail.org/track.user.last.login.html

4 Reply by ebo

  • ebo
  • Member
  • Offline
  • Registered: 2021-09-06
  • Posts: 5

Re: Last login with postgresql

Im now solving this with parsing pop3 and imap log until Ubuntu 22.04 arrives with Dovecot support for this plugin.

5 Reply by Cthulhu (edited by Cthulhu 2021-09-13 23:19:16)

  • Cthulhu
  • Member
  • Offline
  • Registered: 2019-06-04
  • Posts: 907

Re: Last login with postgresql

I never used pgsql so far, didn't see any benefits over mysql or mariadb.
Maybe it performs a bit better on high loads, where read peformance matters, but for average use it is not worth it.

Even if iRedMail has a focus on database lookup (virtual mail box, login credentials, amavisd filter rules, iredapd, etc), the speed difference would only be measurable within a heavy load and still be bottlenecked by spamhaus lookups and content filters (spam/virus).

Even for maintaining databases, i prefer mysql/mariadb WAY over pgsql.

Maybe you should consider to use mariadb over pgsql for your needs

6 Reply by ebo

  • ebo
  • Member
  • Offline
  • Registered: 2021-09-06
  • Posts: 5

Re: Last login with postgresql

Yeah, if had known this before we where going live with 7500 users on PSQL..

I will need to wait untill 22.04 or a better time to migrate PSQL->MariaDB