postgresql-8.4.0-1-windows.exe - initdb: libintl-8.dll was not found and even more...

I installed the postgresql-8.4.0-1-windows.exe on MS Server 2003 R2 Enterprise Edition SP2
into d:\postgresql directory and set PATH to d:\postgresql\bin.

Then I cd to d:\postgresql\bin.

When I tried command
initdb.exe -D e:\pg_cluster (in d:\postgresql\bin directory)
error messagebox popup:
"This application has failed to start because libintl-8.dll was not found."

As I see d:\postgresql\bin\libintl-8.dll is exist.
Same problem with libiconv-2.dll.

I copy libintl-8.dll and ibiconv-2.dll into windows system directory (c:\winnt)

After that I have error.
=================================
D:\postgresql\bin>initdb.exe -D e:\pg_cluster
could not find a "initdb.exe" to execute
could not find a "initdb.exe" to execute
could not find a "initdb.exe" to execute
The program "postgres" is needed by initdb but was not found in the
same directory as "initdb".
Check your installation.
=================================
D:\postgresql\bin>initdb.exe and D:\postgresql\bin>postgres.exe exist.

I have no idea what wrong.
Help, please.

This strange.

But, one reason, I can see, is:
You should be using a user - who is having administrator rights.

Please try to use initdb using a user, who is not having administrator rights.
i.e. postgres

Create batch file - D:\initdb.bat (as below):
------------------------------
REM START
D:\postgres\initdb.exe -D e:\pg_cluster
REM END
------------------------------

Now run this batch file using postgre user.
runas /env /user:postgres D:\initdb.bat

NOTE: This will ask password of the 'postgres' user (It is the same password, you had provided during installation).

This message was edited 1 time. Last update was at 14 Aug 2009 03:47:10

Thanks, it has worked. What it means? Why not with admin rights?
Should I execute all management commands on behalf of postgres system user?
Further I wish to restore dump by a command pg_restore.

This message was edited 1 time. Last update was at 14 Aug 2009 04:00:25

PostgreSQL does not allow to run as an administrator user. (Because of some security issue.)
You may find details about it from PostgreSQL manual (documentation).

Hence, programs like initdb, pg_ctl, postgres, postmaster, etc. should be used only using the user, who does not have administrator rights.

Ashesh_V wrote:
Hence, programs like initdb, pg_ctl, postgres, postmaster, etc. should be used only using the user, who does not have administrator rights.

I understood. But postgresql's win32 installator requires administrative rights, and installator fail during the cluster initialization (services not installed too).
Only your advice+installing over again after manual initdb helps in this situation.
With admin rights installator will fail to init cluster, without admin rights installation can't be done.

This message was edited 1 time. Last update was at 14 Aug 2009 06:02:44

We need administrator rights to create the installation directory, creation of the user 'postgres', create the postgresql service, etc...
We usually initialize the cluster using the postgres user only.
But, problem occurs - when the normal user does not have access to read the Parent folder.

(i.e. Program Files )

Ashesh_V wrote:
We need administrator rights to create the installation directory, creation of the user 'postgres', create the postgresql service, etc...
We usually initialize the cluster using the postgres user only.
But, problem occurs - when the normal user does not have access to read the Parent folder.
(i.e. Program Files )

I am a little confused.
Should I run installer with admin rights or without so installer can initdb automatically without failure?
"Parent directory" - directory where server binaries are located?
In my case postgres user have read+execute access on whole disk D: where I setup it.

You need to run the installer as an administrator.
It will take care - what needs to be done.

i had tried mingw installer but it gives lbintl-8dll not found wht i should do ?!

Ajinkya,

Where did you get this installer?
You may need to the person/company, who provided that installer.