Re: pgAgent installation fails - LIBPQ.DLL is missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64

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