On Aug 12, 2010, at 2:43 PM, Peter Geoghegan wrote: > 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.
pgpass.conf file should in %APPDATA%\postgresql directory of user/account, which you will use to start the pgagent. Suppose if you want start pgagent as user peter account on windows, then you have to keep the pgpass.conf file in %APPDATA%\postgresql directory of peter account. -Vibhor -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
