Jeremy T. Bouse:
[ Charset windows-1252 converted... ]
> On 1/28/2017 12:16 PM, Wietse Venema wrote:
> > Sorry about that, I should have written 'import_environment'. That
> > setting controls what Postfix uses internally, including in its
> > pgsql client.
> >
> > Wietse
>
> Okay so am I doing something wrong here... I've got the following in
> my main.cf:
>
> import_environment = PGPASSFILE=/etc/postfix/pgsql/.pgpass
> virtual_alias_maps = proxy:pgsql:/etc/postfix/pgsql/virtual_alias.cf,
> proxy:pgsql:/etc/postfix/pgsql/virtual_alias_domainaliases.cf
> virtual_mailbox_maps = proxy:pgsql:/etc/postfix/pgsql/virtual_mailbox.cf,
> proxy:pgsql:/etc/postfix/pgsql/virtual_mailbox_domainaliases.cf
> virtual_mailbox_domains = proxy:pgsql:/etc/postfix/pgsql/virtual_domains.cf
>
> With the /etc/postfix/pgsql/*.cf files all following the format:
>
> user = DB_USER
> password = DB_PASSWD
> hosts = psqldb.undergrid.net
> dbname = postfixadmin
> query = <SQL QUERY>
You can set the access permissions ON /etc/postfix/pgsql/virtual_alias.cf,
/etc/postfix/pgsql/virtual_alias_domainaliases.cf, etc. There is
no need for those to be world-readable.
Wietse
