Re: PostgreSQL+Postfix inquiry

2017-01-28 Thread Jeremy T. Bouse
On 1/27/2017 11:41 PM, Viktor Dukhovni wrote: >> On Jan 27, 2017, at 6:37 PM, Jeremy T. Bouse >> wrote: >> >> I tried to set up a PGPASSFILE >> that I 'chmod 0600' and 'chown postfix' then added the >> export_environment setting to my main.cf pointing to it. > The correct setting is "import_envir

Re: PostgreSQL+Postfix inquiry

2017-01-28 Thread Wietse Venema
Jeremy T. Bouse: > I tried to set up a PGPASSFILE that I 'chmod 0600' and 'chown > postfix' then added the export_environment setting to my main.cf > pointing to it. Viktor Dukhovni: > The correct setting is "import_environment" not "export_environment". Jeremy T. Bouse: > Thanks Viktor... I'd on

Re: PostgreSQL+Postfix inquiry

2017-01-28 Thread Jeremy T. Bouse
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:

Re: PostgreSQL+Postfix inquiry

2017-01-28 Thread Wietse Venema
Jeremy T. Bouse: > With the /etc/postfix/pgsql/*.cf files all following the format: > > user = DB_USER > password = DB_PASSWD > hosts = psqldb.undergrid.net > dbname = postfixadmin > query = > > Everything is working fine... So with the PGPASSFILE set in > import_environment and I've con

Re: PostgreSQL+Postfix inquiry

2017-01-28 Thread Wietse Venema
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

Re: PostgreSQL+Postfix inquiry

2017-01-28 Thread Jeremy T. Bouse
On 1/28/2017 6:10 PM, Wietse Venema wrote: > 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 c

Re: PostgreSQL+Postfix inquiry

2017-01-28 Thread Wietse Venema
Jeremy T. Bouse: [ Charset windows-1252 converted... ] > On 1/28/2017 6:10 PM, Wietse Venema wrote: > > 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