Slim PostgreSQL Clients
On a typical client you may not want to install the whole PostgreSQL server software with all bells and whistles.
Currently it is not possible to install only the minimum interface through the one click installer, so there is a pre-built package in the download section of the IBK website with an installer for just that.
The installer is named pgclient-X.X.X, where X.X.X stands for the PostgreSQL version. Download the zip file and unpack the msi file. Double-click the msi file to run the installer, confirm the EULA and the installation folder and let the installer add the files and make the requires settings:
On Windows 7 no further action is required, the PostgreSQL client software should be immediately available. On other Windows versions it might be necessary to reboot.
Manual setup
If you want to manually install the required files for some reason (maybe because no installer package for your favorite PostgreSQL version is available), you can do the following to find out what files are needed:
- Locate libpg.dll in the PostgreSQL server installation
- Get the Dependency Walker and let in analyze that dll
- Get listed dependency dll's that are in the PostgreSQL bin directory
- Copy these dll's to the client machine in a distinct directory
- Add that directory to the system PATH environment variable
For 8.4.1 the required dll's are: comerr32.dll, gssapi32.dll, k3sprt32.dll, krb5_32.dll, libeay32.dll, libiconv-2.dll, libintl-8.dll, libpq.dll, msvcr71.dll and ssleay32.dll.
For other versions the required dlls may be different, so the only clean way is to use the dependency walker to find out as explained above.