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-configuration

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
[email protected]
http://www.webpros.com/
________________________________________
From: volker.jaenisch--- via dovecot <[email protected]>
Sent: Monday, January 26, 2026 9:03 AM
To: Aki Tuomi via dovecot <[email protected]>
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 -- [email protected]

To unsubscribe send an email to [email protected]

_______________________________________________
dovecot mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to