[PORTS] Java database connectivity postgresql

[shaveta chawla]

------=_Part_32789_8609816.1181300223431
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

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

Regards
sss1

------=_Part_32789_8609816.1181300223431
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello Sir,<br>
<br>
I am trying to connect postgresql to java but I am not able .<br>
Actually problem is that i have confugured the postgresql.conf and pg_hba.conf files as per given in the documentation<br>
I had installed postgresql 8.2 version on Fedora Core 4<br>
in my pg_hba.conf file my settings are as follows<br>
<br>
# &quot;local&quot; is for Unix domain socket connections only<br>
local&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
trust<br>
# IPv4 local connections:<br>
host&nbsp;&nbsp;&nbsp;
all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<a href="http://127.0.0.1/32">127.0.0.1/32</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
trust<br>
# IPv6 local connections:<br>
host&nbsp;&nbsp;&nbsp;
all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
::1/128&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
trust<br>
<br>
and in postgesql.conf file<br>
<br>
listen_addresses = &#39;*&#39; <br>
port = 5432 <br>
max_connections = 100 <br>
<br>
then i started the server with the following command<br>
./postmaster -D /usr/local/pgsql/data -i <br>
&nbsp;server was started but i m not able to telnet<br>
telnet localhost 5432<br>
<br>
in the log files this error is coming<br>
LOG:invalid length of startup packet<br>
<br>
Plz help me asap. as i urgently need it in my project<br>
<br>
Regards<br>
sss1<br>

------=_Part_32789_8609816.1181300223431--

[Jörg Heßdörfer]

Hi,

Post by shaveta chawla
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
host all all 127.0.0.1/32 trust
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.

Post by shaveta chawla
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.: [phone]
Fax.: [phone]

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings