Jeremy T. Bouse: > > https://www.postgresql.org/docs/current/static/libpq-pgservice.html > > https://www.postgresql.org/docs/current/static/libpq-connect.html > > https://www.postgresql.org/docs/current/static/libpq-pgpass.html > > > > I need to test that. > > > > Regards, > > Christoph > This would seem like a much cleaner and secure means by which to do > it and provide additional configuration options in the process but I'd > be curious how it might be affected when using proxy:pgsql:* as well as > simply pgsql:* mappings.
You could set PGPASSFILE via main.cf:export_environment, and set permissions (group read for 'postfix'). But, there is no need for passwords in main.cf; If you configure the table as pgsql:/path/to/file, you can reduce access permission for that file. Wietse