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: "burkha...@konsultaner.de" <burkha...@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-le...@dovecot.org > _______________________________________________ dovecot mailing list -- dovecot@dovecot.org To unsubscribe send an email to dovecot-le...@dovecot.org
