Difference between revisions of "Install Postgresql client driver"

From Gestinux Wiki
Jump to navigation Jump to search
Line 7: Line 7:
 
* sudo apt-get install postgresql-client
 
* 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)''
 
* 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 a 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 [http://www.enterprisedb.com/products-services-training/pgbindownload 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 a Gestinux version copy the '''libintl.dll''' file for x86-32 or the '''libintl-8.dll''' file for x86-64
 +
  
 
[[Installing#Installation_of_Gestinux_1.0_.28release_candidate.2C_nearly_stable.29|Go on installation]]
 
[[Installing#Installation_of_Gestinux_1.0_.28release_candidate.2C_nearly_stable.29|Go on installation]]

Revision as of 18:34, 28 February 2014

 Français

{{#CustomTitle:Client for a PostgreSql database}}

Under Ubuntu, to run a client of a Postgresql database you have to install an additional driver.

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 a 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 a Gestinux version copy the libintl.dll file for x86-32 or the libintl-8.dll file for x86-64


Go on installation