Hi Richi,
You create a user in PostgreSQL (arbitrary name, e.g. dbuserofdovecot) and use it in the Dovecot settings in the connection string:
/etc/dovecot/dovecot-sql.conf.ext
driver = pgsql connect = host=127.0.0.1 dbname=mymailserverdb user=dbuserofdovecot password=P4ssw0rdForDBUserOfDovecot ...
This way the connection is made through TCP to a host of your choice, not a Unix socket.
Yours, Reg Barclay
Gesendet: Montag, 19. Februar 2024 um 21:26 Uhr Von: "burkhardt@konsultaner.de" <burkhardt@konsultaner.de> An: "dovecot@dovecot.org" <dovecot@dovecot.org> Betreff: Valid Docs for Dovecot with postgresql
Hi! The docs for dovecot with postgres are outdated and I somehow cannot connect from my dovecot instance to my postgresql database.
I tried a lot but the debug output dosn't help me.
What user is actually trying to connect to the postgresql? the dovecot user or root or the actual user from the connection config? I want to connect locally. Do I use password or md5 or peer with a map to connect? (tried all)
simple console with pgsql command works fine.
I found a couple of "How tos" but nothing helped. Are there any potential version conflict? I'm on 2.3.16 with postgresql 16.
Thanks! Richi
dovecot mailing list -- dovecot@dovecot.org To unsubscribe send an email to dovecot-leave@dovecot.org