Windows – PostgreSQL server install – can’t find or access dll

postgresqlwindows

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 …"

Error installing PostgreSQL server

(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

Best Answer

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
Related Topic