Preparing the Database Server for JDBC

Because Java does not support using unix sockets the PostgreSQL server must be configured to allow TCP/IP connections. Starting with server version 8.0 TCP/IP connections are allowed from localhost . To allow connections to other interfaces than the loopback interface, you must modify the postgresql.conf file’s listen_addresses setting.

For server versions prior to 8.0 the server does not listen on any interface by default, and you must set tcpip_socket = true in the postgresql.conf file.

Once you have made sure the server is correctly listening for TCP/IP connections the next step is to verify that users are allowed to connect to the server. Client authentication is setup in pg_hba.conf . Refer to the main PostgreSQL documentation for details. The JDBC driver supports the trust , ident , password , md5 , gss and crypt authentication methods.