PostgreSQL server install - can't find or access dll

Question

When i try to install postgresql-9.0.4-1-windows.exe, somewhere at the end of the installation i get an error. "... libintl-8.dll was not found ..."

(same as in this thread: http://forums.enterprisedb.com/posts/list/2526.page direct link: http://forums.enterprisedb.com/posts/downloadAttach/147.page;jsessionid=43B371483530826B5E7EE9151F79279C )

Everything i found concerning this error suggests a permissions issue of the Windows user account, but i was logged in as Administrator. I tried to install the PostgreSQL server on another disk than the default (D:\Apps), together with the data directory. The data directory was created and the concerning dll (libintl-8.dll) was present.

Consequences are that the PostgreSQL Windows service cannot be started.

I am not a Windows expert, so my question is two-fold:

• can an administrator have diminished privileges causing this error?
• can this error have another cause than priviliges, which?

Thanks in advance for any insight

Answer 1

As you see from screenshot it's issue related to initdb,exe, which creates/initializes new database cluster. As PostgreSQL documentation stays:

initdb must be run as the user that will own the server process, because the server needs to have access to the files and directories that initdb creates. Since the server cannot be run as root, you must not run initdb as root either. (It will in fact refuse to do so.)

According to installer's doc there should be install-postgresql.log logfile in your %TEMP%, so you can get more info (additional there is --debuglevel installer option, run with --help to see more description).

If you encounter any problems during installation, please check the logfile that is created in /tmp on Linux or Mac OS X or %TEMP% on Windows. The file will be called install-postgresql.log. The logfile may contain the superuser password you specified during the installation, which should be replaced before sharing the log with anyone.

Are you using default postgres superuser/service account ? I don't know if this helps, but you try to remove it before (clean) installation by (using cmd with admin rights):

net user postgres /del

Answer 2

Just because you are logged in as Administrator doesn't mean you can access all files - it just means you can give yourself the privileges to access every file.

Check the privileges on the DLL in question and make sure the user that runs the installation and the postgres service account have both read privileges on that file