pgAgent win32 service setup
От | Kev |
---|---|
Тема | pgAgent win32 service setup |
Дата | |
Msg-id | 7aabf6d1-c0a8-4d4c-8c65-8fc825ae9db5@k5g2000pra.googlegroups.com обсуждение исходный текст |
Список | pgadmin-support |
Hi, I've been trying to install pgAgent on a new server, and running into the same problems as described here: http://old.nabble.com/pgAgent-absent-from-win32-beta-distributions--td23139611.html However, the old solutions have not seemed to help. The service is running as the local service account (same as the old server), and the connection string passed on the command-line is identical to the old server, on which pgAgent still starts up correctly and works. On the new server, the error is "Couldn't create the primary connection (attempt 10): fe_sendauth: no password supplied". The pgpass file is in the same location, C:\Documents and Settings\Default User \Application Data\postgresql\, that allows it to work on the old server (just to be sure, I renamed just that file to something else, and sure enough, pgAgent would no longer start, giving the above error.) If I copy the password from the pgpass file and pass it on the command line, it works fine, but of course, that's not recommended for security reasons. So I know the pgpass file contents are right. Also I've checked the host and port many times, and an identical copy of that file lets me log in via pgAdminIII. I know the permissions on the pgpass file are right because they're identical to the old server. Oddly enough, if I use 'DEBUG -l 2', on both servers it fails due to the password being blank. But I go 'net start pgagent' and on the old one it succeeds, but the new one it fails. The command line strings are identical. What else is there for me to check? Thanks in advance for your help, Kev
В списке pgadmin-support по дате отправления: