N/APosted on - 06/14/2011
I am on the process of making codes, while on testing I encountered this error message regarding SQL.
It seems there is a problem with my database that is not running well. I looked into my drive and searched, but didn't find libpq.dll, but I am pretty sure that I have PostgreSQL installed successfully. Because I can use pgAdminIII to manage databases, what came to my mind is that, why is the system looking for a file, while my installation of PostgreSQL is successful, and no error message was posted while installing it? Please help me find why the system is asking me for a file libpq.dll.
psql.exe – Unable To Locate Component
This application has failed to start because libpq.dll was not found. Re-installing the application may fix this problem.
PostgreSql error libpq.dll was not found
The issue that you're experiencing is most likely a configuration error and involves the method in which windows locates .dll files as well as the actual location of that .dll file, you can check this post on the msdn site for an idea of what I’m talking about: Search Path Used by Windows to Locate a DLL
As it relates to the root cause of your problem, this is most likely a result of changes in the way PHP links libpq.dll, I've always preferred to use wamp server as opposed to psql, but the problem as I said is around how windows locates .dll files.
The fact that you didn’t post your operating system or program version is a bit of a limitation but I’m assuming you're using XP and an older version of psql, as this error is known to occur in build 5236. If that is the case download libpq.dll from link and replace the one in your program folder directory X:program filesnuspherephped (change the "X" to your drive letter).
If all else fails download the latest version of postgresql from their home page.