Re: Java database connectivity postgresql - Mailing list pgsql-ports

From Jörg Heßdörfer
Subject Re: Java database connectivity postgresql
Date
Msg-id 200706081314.04450.Joerg.Hessdoerfer@sea-gmbh.com
Whole thread Raw
In response to Java database connectivity postgresql  ("shaveta chawla" <omshanti2all@gmail.com>)
List pgsql-ports
Hi,

On Friday 08 June 2007 12:57, shaveta chawla wrote:
> Hello Sir,
>
> I am trying to connect postgresql to java but I am not able .
> Actually problem is that i have confugured the postgresql.conf and
> pg_hba.conf files as per given in the documentation
> I had installed postgresql 8.2 version on Fedora Core 4
> in my pg_hba.conf file my settings are as follows
>
> # "local" is for Unix domain socket connections only
> local   all         all                                 trust
> # IPv4 local connections:
> host    all         all         127.0.0.1/32            trust
> # IPv6 local connections:
> host    all         all         ::1/128                 trust
>
> and in postgesql.conf file
>
> listen_addresses = '*'
> port = 5432
> max_connections = 100
>
> then i started the server with the following command
> ./postmaster -D /usr/local/pgsql/data -i
>  server was started but i m not able to telnet
> telnet localhost 5432
>
> in the log files this error is coming
> LOG:invalid length of startup packet

This is to be expected. Connection via telnet to the DB is not supported ;-)
What the LOG entry tells you, though, is that the database is waiting for
network connections, so your setup should be OK.
Please try with psql: 'psql -h localhost -U <your username> template1'
You should either get an errormessage, or a login prompt.

>
> Plz help me asap. as i urgently need it in my project
>
> Regards
> sss1

Greetings,
    Jörg
--
S.E.A. Datentechnik GmbH
Jörg Heßdörfer, Leiter Softwareentwicklung
Linder Höhe
51147 Köln
Tel.: +49-2203-98007-0
Fax.: +49-2203-98007-14

Informationen nach 37aHGB, 35a GmbH-Gesetz:
S.E.A.
Science & Engineering Applications
Datentechnik GmbH
Sitz der Gesellschaft Köln
Handelsregister Köln HRB 27016
Geschäftsführer: Dr. Gerd Schmitz, Wolfram Koerver

pgsql-ports by date:

Previous
From: "shaveta chawla"
Date:
Subject: Java database connectivity postgresql
Next
From: "Phil Mills"
Date:
Subject: Compilation failure: 8.2.4 and 8.1.0 under XPPro/MinGW