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

From Piotr Czekalski
Subject Re: pgAgent installation fails - LIBPQ.DLL is missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64
Date
Msg-id 4D39F5D3.8060708@techbaza.pl
Whole thread Raw
In response to Re: pgAgent installation fails - LIBPQ.DLL is missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64  (Piotr Czekalski <pczekalski@techbaza.pl>)
Responses Re: pgAgent installation fails - LIBPQ.DLL is missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64  (Stane Mikolič <stane.mikolic@gmail.com>)
List pgadmin-support
<br /> Some more information -when you finally make it working remember that your service is WoW one, thus you won't be
ableto see that in regular service manager.<br /><br /> To install PgAgent run <code>"C:\Program Files\pgAdmin
III\pgAgent.exe"INSTALL pgagent –u OSUser –p OSUSerPassword <connect-string></code><br /> Watch registry
(<code>HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\pgAgent)</code>to see cofiguration details and acknowledge
correctinstall.<br /> To manage service, use:<br /><code>net start pgagent</code> – to start service<br /><code>net
stoppgagent</code> – to stop service.<br /><br /> Hope that helps,<br /><br /> Piotr<br /><br /> W dniu 2011-01-21
21:58,Piotr Czekalski pisze: <blockquote cite="mid:4D39F390.3080107@techbaza.pl" type="cite"> Hello there.<br /><br />
Iwas facing the same problem.<br /> I think the real reason is PgAgent is an x86 code, actually running with means of
WoWon your x64 Windows System, while Postgres 9.x is truly x64 now thus you do have a LIBPQ.DLL byt 64bit one, while
PgAgentis looking for x86 one.<br /><br /> I've found the following workaround.<br /> Install somwhere else x86 version
ofPostgreSQL for Windows (actually I've used an old 8.4.1 form our old server), copy the following libraries:<br /><br
/><em>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<br /><br /></em>to the folder where PgAgent is
located.<br/> This way I made it working. Looking forward for x64 release of PgAgent (currently unavailable I
think).<br/><br /> Regards,<br /><br /> Piotr Czekalski<br /><br /> TECHBAZA.PL Development Team.<br /><br /><pre
class="moz-signature"cols="72">-- 
 

--------------------------------------------------------------
"TECHBAZA.PL" Sp. z o.o.
Technologie WEB, eDB & eCommerce
Oddział Gliwice
ul. Chorzowska 50
44-100 Gliwice
tel. (+4832) 7186081
fax. (+4832) 7003289</pre></blockquote><br /><br /><pre class="moz-signature" cols="72">-- 

--------------------------------------------------------------
"TECHBAZA.PL" Sp. z o.o.
Technologie WEB, eDB & eCommerce
Oddział Gliwice
ul. Chorzowska 50
44-100 Gliwice
tel. (+4832) 7186081
fax. (+4832) 7003289</pre>

pgadmin-support by date:

Previous
From: Piotr Czekalski
Date:
Subject: Re: pgAgent installation fails - LIBPQ.DLL is missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64
Next
From: Stane Mikolič
Date:
Subject: Re: pgAgent installation fails - LIBPQ.DLL is missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64