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
, and
crypt
authentication methods.