Interesting. If I make a direct query as per your example I am presented with an "unsupported dictionary type" error, which I guess means that the version of postfix that freebsd packages doesn't support postgres?
On Mon, Feb 21, 2022 at 4:42 PM Wietse Venema <wie...@porcupine.org> wrote: > > Nathan Van Ymeren: > > postmap: dict_proxy_lookup: > > table=pgsql:/usr/local/etc/postfix/pgsql-virtual-mailbox-domains.cf > > flags=warn_dup|lock|utf8_request key=example.org -> status=2 result= > > postmap: fatal: table > > proxy:pgsql:/usr/local/etc/postfix/pgsql-virtual-mailbox-domains.cf: > > query error: Application error > > The proxymap server returned status 2 (PROXY_STAT_RETRY), meaning > there was a lookup error. > > You may find some proxymap server logging about the error that was > actually happening there. > > If you can't find the logs, you can eliminate the proxymnap in the > middle, and make a direct query to the pgsql database: > > postmap -q example.org > pgsql:/usr/local/etc/postfix/pgsql-virtual-mailbox-domains.cf > > Wietse
