Re: createdb - missing pq.dll after compile/install?

Mike,

[...]
>I have a new minor problem.  When I compile/install PostgreSQL 7.4 from
>scratch, when run one of the scripts such as createdb.exe, I get a windows
[...]

AFAIK, createdb is a shell script. It should not have a ".exe" extension. 

[...]
>error message that the "pq.dll" could not be found, and that I should try
>reinstalling.  For fun, I tried reinstalling, and I still get the error.  If
>I copy the pq.dll (which really has been installed in /usr/lib) to the
>windows/system32 folder, it works.  I deleted the DLL, then tried installing
>the precompiled PostgreSQL from my cygwin download package, and it worked
>without asking for the pq.dll - I found that this time the dll had also been
>installed in /usr/bin.  Is this something I should just know to do after I
>compile/install, or is it something I'm missing in the source code or my
>configuration settings?
[...]

There are some predefined paths and techniques a unix-like environment is 
awaare of. Such a technique is using a system variable (LD_CONFIG_PATH) to 
specify the place where the dynamic libraries are to be found. I.e. I 
configure/install my "app" as "/usr/local/app" with dynamic libs in 
"/usr/local/app/lib" but to actually use it I must do a 
"LD_CONFIG_PATH=$LD_CONFIG_PATH:/usr/local/app/lib" and "ldconfig", so that 
dynamic linker be able to find my libraries.

Well, windows doesn't have such a feature and neither does its POSIX layer, 
cygwin. In their case, the problem solves either by placing the dll in a place 
that already exists in the PATH variable, or to add the place to the PATH 
variable (i.e., if your Postgresql dlls are in /usr/local/pgsql/lib, then you 
must do a "PATH=$PATH:/usr/local/pgsql/lib" before you start any application 
that needs them).

SLao

__________________________________________________________________
McAfee VirusScan Online from the Netscape Network.
Comprehensive protection for your entire computer. Get your free trial today!
http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397

Get AOL Instant Messenger 5.1 free of charge.  Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster