Re: Problem with Java-SQL connection, postgresql.conf file

Hi, Christopher,

Christopher Bruhn wrote:

> Moreover I searched for the postgresql.conf file but I could not find it
> among the files extracted from postgresql-8.2dev-503.jdbc3.jar.

> Can you tell me if I use the Driver in a wrong way, where I can find
> the postgresql.conf file and if I need to make changes in this file?

The postgresql.conf file is the main configuration file for the
PostgreSQL server. The exact place of installation depends on how the
Postmaster itsself is installed, but it is likely to be found in /etc or
the postgresql main cluster directory on unices.

If your postmaster is set up to only accept connections via unix
sockets, but not via TCP, then you have to change postgresql.conf and
pg_hba.conf. As all is on the same server, make him listen on 127.0.0.1
and allow access from there.

Btw, for testing, you can use command line access (if you have) and the
psql utility. If you can connect via "psql usr_web593_1", but not via
"psql -h localhost -p 5432 usr_web593_1" then postgresql does not accept
tcp connections via localhost.

Btw, it might also be that the server and client disagree on mandatory
SSL usage, but that likely leads to different exceptions.

Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org