SQL client software

Since we are dealing with Java a JDBC™ a corresponding driver is needed to connecting applications to our Postgresql server:

Figure 647. Installing Mysql driver using aptitude. Slide presentation Create comment in forum
#> apt-get install libpostgresql-jdbc-java

This provides:

# dpkg -L libpostgresql-jdbc-java
/usr/share/java/postgresql.jar
/usr/share/java/postgresql-jdbc4.jar
...

A second approach works by adding the following dependency to your Maven project:

Figure 648. Installing Postgresql driver using Maven. Slide presentation Create comment in forum
<dependency>
  <groupId>postgresql</groupId>
  <artifactId>postgresql</artifactId>
  <version>9.1-901-1.jdbc4</version>
</dependency>
#> mvn compile

#> ls ~/.m2/repository/mysql/mysql-connector-java/8.0.12
mysql-connector-java.jar ...