Setting up pgpass.conf for the postgres OS user on windows for pgAgent

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Setting up pgpass.conf for the postgres OS user on windows for pgAgent
Date: 2010-08-12 18:43:50
Message-ID: AANLkTi=HrVh0KXcyQApTTg_hv2StJ3Xgp2-B-hkgaGk+@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I would like to set up pgAgent on windows. I'm using the EDB 8.4.4
package. I know that it is bad practice to put the password directly
in the conninfo string, so I've avoided that. I want to use pgpass
authentication, per the instructions for pgAgent.

I get an fe_sendauth error message in windows event viewer for the
pgagent service when I attempt to start pgagent. I'm not sure where I
should put the pgpass.conf file so that it's in the postgres service
account's %APPDATA%\postgresql directory. Perhaps someone could give
further direction.

--
Regards,
Peter Geoghegan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-08-12 18:44:23 Re: foreign keys and inheritance problem
Previous Message Edoardo Panfili 2010-08-12 18:37:31 Re: foreign keys and inheritance problem