Install Postgresql client driver

From Gestinux Wiki
Revision as of 04:36, 14 January 2017 by Tahitibub (talk | contribs)
Jump to navigation Jump to search
 Français

{{#CustomTitle:Install a PostgreSQL database client library}}

On Linux Debian (Ubuntu, Mint) :

To run a client of a PostgreSQL database you have to install an additional library.

You do this in a terminal window using the following two commands:

sudo apt-get install postgresql-client
sudo ln -s /usr/lib/libpq.so.5.4  /usr/lib/libpq.so  # adapt to the actual postgres version


On Windows :

  • In the standalone configuration, if your PostgreSQL server's version is the same as the Gestinux version (x86-32 or x86-64) then you can use the client's libraries from the PostgreSQL server’s installation directory, otherwise follow the client-server configuration method.
    • Go to <PostgreSQL server's installation directory>\bin
    • You should copy the libpq.dll, libeay32.dll and ssleay32.dll files to the WINDOWS directory (%windir%)
    • Then according the Gestinux version copy the libintl.dll file for x86-32 or the libintl-8.dll file for x86-64


  • In the client-server configuration you need to download client’s libraries from the PostgreSQL Binaries page
    • Download an archive of PostgreSQL binaries x86-32 or x86-64 (according Gestinux version)
    • Extract all files
    • Go to <Extracted directory>\pgsql\bin
    • You should copy the libpq.dll, libeay32.dll and ssleay32.dll files to the WINDOWS directory (%windir%)
    • Then according the Gestinux version copy the libintl.dll file for x86-32 or the libintl-8.dll file for x86-64

Reminder : you have to download the most recent version of the binaries which contains the "libintl.dll" file. As of January 2017, these are binaries of the 9.3.15 version. More recent binaries doesn't work.

Go on installation