Re: The system cannot execute the specified program in windows xp (service pack 3)

Thanks for your help.
But now facing new problem. While running the "initdb.exe -D ..\data -E UTF-8 --locale=C -U postgres" command the following unknown language printed. This should be in english.
Please help me out.

Filerna tillhörande databasen kommer att ägas av användaren "Administra
Denna användare måste också köra server-processen.

Databasklustret kommer initieras med lokalen C.
Databasens standardtextsökningskonfiguration har satts till "english".

skapar katalog ../data ... ok
skapar underkataloger ... ok
väljer initialt värde för max_connections ... 100
väljer initialt värde för shared_buffers ... 32MB
skapar konfigurationsfiler ... ok
skapar databasen template1 i ../data/base/1 ... ok
initierar pg_authid ... ok
initierar beroenden ... ok
skapar systemvyer ... ok
laddar systemobjektens beskrivningar ... ok
skapar konverteringar ... ok
skapar kataloger ... ok
sätter rättigheter för inbyggda objekt ... ok
skapar informationsschema ... ok
loading PL/pgSQL server-side language ... ok
kör vacuum på databasen template1 ... ok
kopierar template1 till template0 ... ok
kopierar template1 till postgres ... ok

VARNING: slår på autentiseringsmetod "trust" för lokala anslutningar.
Du kan ändra detta genom att redigera pg_hba.conf eller använda
flaggan -A nästa gång du kör initdb.

Det lyckadas. Du kan nu starta databasservern med:

"postgres" -D "../data"
eller
"pg_ctl" -D "../data" -l logfil start

Thanks,

Prabakaran A

---- On Fri, 31 Dec 2010 03:13:54 +0530 John R Pierce <pierce(at)hogranch(dot)com> wrote ----

On 12/30/10 6:39 AM, prabakaran.a wrote:
> Dear All,
>
> We are using Postgresql 9.0.1(binary) in our Java Application.
>
> In some windows xp sp3 machines, we found that the executable files
> related to postgresql are not working. while executing those files(ex:
> initdb.exe), following error thrown in console "The system cannot
> execute the specified program" .Other executable files not related to
> postgresql working fine.
>
> By comparing working and non-working machines, came to know that some
> *.VC90.* files and directories are missing from C:\Windows\WinSxS\
> Then we copied *.VC90.* related files and directories from
> C:\Windows\WinSxS\Manifests\ ,C:\Windows\WinSxS\Policies\ (working
> system) to non-working system.
> After that, executable files under postgresql seems to be working but
> facing locale problems.(ex:Informations are in swedish).
>
> If any one knows please help me out.

Blindly copying files into the Windows "Side by Side" assembly cache
sounds very sketchy to me.

My guess is, those systems need the VC90 runtime redistributables
package installed.

http://www.microsoft.com/downloads/en/details.aspx?familyid=a5c84275-3b97-4ab7-a40d-3802b2af5fc2&displaylang=en
<http://www.microsoft.com/downloads/en/details.aspx?familyid=a5c84275-3b97-4ab7-a40d-3802b2af5fc2&displaylang=en>