[MM3-users] Re: Postfix + MariaDB + Mailman 3 Core

On 28.02.25 07:21, Peter Knowles via Mailman-users wrote:

I'm confused...

We are using postgresql as mailman database.

$ sudo -u postgres psql mailman -c 'SELECT DISTINCT mail_host from mailinglist;'

would list me all used domains which will go into postfix_domains.

$ sudo -u postgres psql mailman -c 'SELECT list_name, mail_host from mailinglist;'

lists all mailing lists with domains. It would require additional rows for all the special purpose addresses like list-bounces@ etc.

You can link postfix directly to postgresql using a pgsql_table.

Then postfix reads the latest in information from the mailman database.

-Gerald