This looks a lot like quota_clone configuration. That still supports dict AFAIK, though it was a bit fiddly to enable when I was having to deal with it as in particular the way you have to set it up in the config file looks quite a bit different.
Only real reference here seems to be the "more complex example using SQL" at the bottom of the examples here: https://doc.dovecot.org/2.4.2/core/plugins/quota_clone.html#example-configur...
Presumably you'd need to just set your sql_driver to pgsql. Otherwise your old setup and the new quota clone config at least looks somewhat similar so I doubt it'll be too much hassle to trial and error your way to success :)
Cheers,
Thomas "Andy" Baugh | Software Development Engineer IV andy.baugh@webpros.com http://www.webpros.com/
From: volker.jaenisch--- via dovecot <dovecot@dovecot.org> Sent: Monday, January 26, 2026 9:03 AM To: Aki Tuomi via dovecot <dovecot@dovecot.org> Subject: Migration to 2.4: Howto get the quota dict writing into a second DB
Dear Dovecot wizards!
I have a question concerning the migration from 2.3.4 to 2.4.1.
On 2.3.4 I had the following config
dict {
sql_store_user_quota =
pgsql:/etc/dovecot/dovecot-sql-store-user_quota.conf
}
With /etc/dovecot/dovecot-sql-store-user_quota.conf:
connect = host=127.0.0.1 port=5433 dbname=dddd user=uuuu password=pppp:
map {
pattern = priv/quota/storage
table = fill_user
username_field = username
value_field = bytes
}
map {
pattern = priv/quota/messages
table = messages_user
username_field = username
value_field = messages
}
On 2.4.1 I tried
dict_map priv/quota/storage {
sql_table = emailaddress_fill
username_field = emailaddress
dict_map_value_field quota_bytes {
type = uint}
}
dict fill {
sql_driver = pgsql
pgsql pg_mc2 {
parameters {
dbname = dddd
host = hhhh
password = ppppp
user = uuuuu
}}
}
But it is doing nothing. Am sure I am missing something here (I guess
howto connect these config snippets). Any help appreciated.
Cheers,
Volker
--
===========================================================
inqbus Scientific Computing GmbH Dr. Volker Jaenisch
Hungerbichlweg 3 +49 (8860) 9222 7 92
86977 Burggen https://inqbus.de/
===========================================================
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-leave@dovecot.org