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

Iredapd sql connection problem on Ubuntu 22.04 and postgresql.
iredapd.log:
"Error while creating SQL connection: NoSuchModuleError("Can't load plugin: sqlalchemy.dialects:postgres")"

python3-sqlalchemy Version: 1.4.31+ds1-1b

I found the solution another forum:

Resolution
SQLAlchemy 1.4.x has removed support for the postgres:// URI scheme, github.com/sqlalchemy/sqlalchemy/issues/6083. To maintain compatibility, perform the following before setting up connections with SQLAlchemy:

paste it iredapd/libs/utils.py under the line "uri = '%s://%s:%s@%s:%d/%s' % (dbn, _user, _pw, _server, _port, _name)":

if uri.startswith("postgres://"):
    uri = uri.replace("postgres://", "postgresql://", 1)

thanks:
Gabor