Обсуждение: Stack Builder probably installs erroneous version of pgAgent 3.4.0-1 on Win32

Hello all,

I'm not totally sure I am posting to the right mailing list - otherwise
please tell me where I should send this message

We tried to install pgAgent on a Windows XP-SP3 installation of
PostgreSQL 9.5.1-1, using the bundled Stack Builder.
The installer fails at the end saying that :
- it "Could not create or modify the pgpass.conf file..."
- it "Failed to install the pgAgent service"

Looking at the install log, we could find several "Unknown error while
running..." messages (should I include the log file ?).

After the installation, if we try to run EXE files in the C:\Program
Files\pgAgent folder, the following programs refuse to launch with a
message from Windows "... is not a valid win32 application." :
- pgagent.exe
- createuser.exe
- validateuser.exe

... whereas the bundled psql.exe seems to work.

Strangely,  those executable files, when copied to my 64-bits Windows 7,
launch without problem (even though they don't find the local PostgreSQL
installation, which is normal).

My best guess is that Stack Builder downloads the Win64 package instead
of the Win32 one - maybe because this package is stored at the wrong
place in the repository ? Or is it a building issue ?

So my questions are :
- Could it be possible to warn the pgAgent Windows packager of this issue ?
- Where can I find a working Win32 installer for pgAdmin 1.22.1(the
production machine is not connected to the Internet and does not have
building tools).

Best regards,
--
*Jean-Marc CHALLIER*
Ce message et toutes les pièces jointes (ci-après le "message") sont établis à l’intention exclusive des destinataires
désignés.Il contient des informations confidentielles et pouvant être protégé par le secret professionnel. Si vous
recevezce message par erreur, merci d'en avertir immédiatement l'expéditeur et de détruire le message. Toute
utilisationde ce message non conforme à sa destination, toute diffusion ou toute publication, totale ou partielle, est
interdite,sauf autorisation expresse de l’émetteur. L'internet ne garantissant pas l'intégrité de ce message lors de
sonacheminement, Atos (et ses filiales) décline(nt) toute responsabilité au titre de son contenu. Bien que ce message
aitfait l’objet d’un traitement anti-virus lors de son envoi, l’émetteur ne peut garantir l’absence totale de logiciels
malveillantsdans son contenu et ne pourrait être tenu pour responsable des dommages engendrés par la transmission de
l’und’eux.
 

This message and any attachments (the "message") are intended solely for the addressee(s). It contains confidential
information,that may be privileged. If you receive this message in error, please notify the sender immediately and
deletethe message. Any use of the message in violation of its purpose, any dissemination or disclosure, either wholly
orpartially is strictly prohibited, unless it has been explicitly authorized by the sender. As its integrity cannot be
securedon the internet, Atos and its subsidiaries decline any liability for the content of this message. Although the
senderendeavors to maintain a computer virus-free network, the sender does not warrant that this transmission is
virus-freeand will not be liable for any damages resulting from any virus transmitted.
 

On Wed, Mar 16, 2016 at 2:05 PM, CHALLIER, JEAN MARC
<jean-marc.challier@atos.net> wrote:
> Hello all,
>
> I'm not totally sure I am posting to the right mailing list - otherwise
> please tell me where I should send this message
>
> We tried to install pgAgent on a Windows XP-SP3 installation of
> PostgreSQL 9.5.1-1, using the bundled Stack Builder.
> The installer fails at the end saying that :
> - it "Could not create or modify the pgpass.conf file..."
> - it "Failed to install the pgAgent service"
>
> Looking at the install log, we could find several "Unknown error while
> running..." messages (should I include the log file ?).
>
> After the installation, if we try to run EXE files in the C:\Program
> Files\pgAgent folder, the following programs refuse to launch with a
> message from Windows "... is not a valid win32 application." :
> - pgagent.exe
> - createuser.exe
> - validateuser.exe
>
> ... whereas the bundled psql.exe seems to work.
>
> Strangely,  those executable files, when copied to my 64-bits Windows 7,
> launch without problem (even though they don't find the local PostgreSQL
> installation, which is normal).
>
> My best guess is that Stack Builder downloads the Win64 package instead
> of the Win32 one - maybe because this package is stored at the wrong
> place in the repository ? Or is it a building issue ?
>
> So my questions are :
> - Could it be possible to warn the pgAgent Windows packager of this issue ?
> - Where can I find a working Win32 installer for pgAdmin 1.22.1(the
> production machine is not connected to the Internet and does not have
> building tools).

The issue is that Windows XP is not supported any more, and not all of
the toolchains in current use produce binaries that will run on it.


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

<div class="moz-cite-prefix">Le 16/03/2016 15:46, Dave Page a écrit :<br /></div><blockquote
cite="mid:CA+OCxoxtDpeEqY4Ru=K-P2E40HbA8Pd+EB5kOnYr9THEgFfZhg@mail.gmail.com"type="cite"> The issue is that Windows XP
isnot supported any more, and not all of the toolchains in current use produce binaries that will run on it.
</blockquote><br/> Thank you very much for pointing this out.<br /><br /> I guess we will have to try and rebuild it
fromthe sources, then...<br /><br /> We also have the option to install Windows 2003 Server instead of XP on the
machine.By any chance, do you know whether this platform is supported by pgAgent ? There does not seem to be an
indicationof the supported versions of Windows in the source code.<br /><br /> Best regards,<br /><div
class="moz-signature">--<br /><b>Jean-Marc CHALLIER</b></div> Ce message et toutes les pièces jointes (ci-après le
"message")sont établis à l’intention exclusive des destinataires désignés. Il contient des informations confidentielles
etpouvant être protégé par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir
immédiatementl'expéditeur et de détruire le message. Toute utilisation de ce message non conforme à sa destination,
toutediffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse de l’émetteur.
L'internetne garantissant pas l'intégrité de ce message lors de son acheminement, Atos (et ses filiales) décline(nt)
touteresponsabilité au titre de son contenu. Bien que ce message ait fait l’objet d’un traitement anti-virus lors de
sonenvoi, l’émetteur ne peut garantir l’absence totale de logiciels malveillants dans son contenu et ne pourrait être
tenupour responsable des dommages engendrés par la transmission de l’un d’eux.<br /><br /> This message and any
attachments(the "message") are intended solely for the addressee(s). It contains confidential information, that may be
privileged.If you receive this message in error, please notify the sender immediately and delete the message. Any use
ofthe message in violation of its purpose, any dissemination or disclosure, either wholly or partially is strictly
prohibited,unless it has been explicitly authorized by the sender. As its integrity cannot be secured on the internet,
Atosand its subsidiaries decline any liability for the content of this message. Although the sender endeavors to
maintaina computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be
liablefor any damages resulting from any virus transmitted.<br /> 

On Thu, Mar 17, 2016 at 1:34 PM, CHALLIER, JEAN MARC
<jean-marc.challier@atos.net> wrote:
> Le 16/03/2016 15:46, Dave Page a écrit :
>
> The issue is that Windows XP is not supported any more, and not all of the
> toolchains in current use produce binaries that will run on it.
>
>
> Thank you very much for pointing this out.
>
> I guess we will have to try and rebuild it from the sources, then...
>
> We also have the option to install Windows 2003 Server instead of XP on the
> machine. By any chance, do you know whether this platform is supported by
> pgAgent ? There does not seem to be an indication of the supported versions
> of Windows in the source code.

The source code should work on any version (well, anything newer than
XP). It's the compiler that's used that is the issue. As long as you
use an MSVC++ version that supports XP you should be fine.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company