Some more information -when you finally make it working remember that
your service is WoW one, thus you won't be able to see that in regular
service manager.
To install PgAgent run |"C:\Program Files\pgAdmin III\pgAgent.exe"
INSTALL pgagent –u OSUser –p OSUSerPassword <connect-string>|
Watch registry
(|HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\pgAgent) |to see
cofiguration details and acknowledge correct install.
To manage service, use:
|net start pgagent| – to start service
|net stop pgagent| – to stop service.
Hope that helps,
Piotr
W dniu 2011-01-21 21:58, Piotr Czekalski pisze:
Hello there.
I was facing the same problem.
I think the real reason is PgAgent is an x86 code, actually running
with means of WoW on your x64 Windows System, while Postgres 9.x is
truly x64 now thus you do have a LIBPQ.DLL byt 64bit one, while
PgAgent is looking for x86 one.
I've found the following workaround.
Install somwhere else x86 version of PostgreSQL for Windows (actually
I've used an old 8.4.1 form our old server), copy the following libraries:
/comerr32.dll, gddapi32.dll, iconv.dll, k5sprt32.dll, krb5_32.dll,
libeay32.dll,. libiconv-2.dll, libintl-8.dll, libpq.dll, libxml2.sll,
libxslt.dll, msvcr71.dll, ssleay32.dll, zlib1.dll
/to the folder where PgAgent is located.
This way I made it working. Looking forward for x64 release of PgAgent
(currently unavailable I think).
Regards,
Piotr Czekalski
TECHBAZA.PL Development Team.
--
--------------------------------------------------------------
"TECHBAZA.PL" Sp. z o.o.
Technologie WEB, eDB& eCommerce
Oddział Gliwice
ul. Chorzowska 50
44-100 Gliwice
tel. (+4832) 7186081
fax. (+4832) 7003289
--
--------------------------------------------------------------
"TECHBAZA.PL" Sp. z o.o.
Technologie WEB, eDB& eCommerce
Oddział Gliwice
ul. Chorzowska 50
44-100 Gliwice
tel. (+4832) 7186081
fax. (+4832) 7003289
