Re: pgAgent installation fails - LIBPQ.DLL is missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64
От | Piotr Czekalski |
---|---|
Тема | Re: pgAgent installation fails - LIBPQ.DLL is missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64 |
Дата | |
Msg-id | 4D39F5D3.8060708@techbaza.pl обсуждение исходный текст |
Ответ на | Re: pgAgent installation fails - LIBPQ.DLL is missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64 (Piotr Czekalski <pczekalski@techbaza.pl>) |
Ответы |
Re: pgAgent installation fails - LIBPQ.DLL is
missing - PostgreSQL 9.0.2 x64 - 2008 Windows Server x64
|
Список | 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 по дате отправления: