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

Hello,

Piotr, your workaroudn works like magic.

What I did...

1. install 9.0.2 x32 on the same machine
2. copy the files from your list to pgAgent folder --> except
comerr32.dll which I couldn't find on my system.
3. uninstal x32 version
4. run "C:\Program Files\pgAdmin III\pgAgent.exe" INSTALL pgagent -u
OSUser -p OSUSerPassword <connect-string>
  - as OSuser I used postgres user which was created during the
installation. I tried with Administrator user but service failed due
to logon
  running from pgAgent director the command was: pgAgent.exe INSTALL
pgAgent -u postreg -p my_password hostaddr=127.0.0.1 dbname=postgres
user=postgres password=my_password

5. net start pgagent

Works like a charm!

Thank you for your help.

Regard, Stane



On Fri, Jan 21, 2011 at 10:08 PM, Piotr Czekalski
<pczekalski@techbaza.pl> wrote:
>
> 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