On 02/04/2019 05:42, Richard Hector via dovecot wrote:

I'm using PostgreSQL for my auth db. I used the example CREATE TABLE statement in the config file, but now I find the fields are too short. I assume dovecot will be fine with 'text' type columns replacing the varchars? Or failing that, I can change the length of the varchar fields?

ALTER TABLE $table ALTER COLUMN $column TYPE VARCHAR($newlenth);

My tables are very different from the dovecot suggested tables and it works, just make sure the queries in dovecot-sql.conf correspond. My tables are different because they hold additional information for routing (the db is shared with exim).