Skip site navigation (1) Skip section navigation (2)

problem with JDBC connection on gumbo nodes

From: "Gayatri Ganpaa" <gayatri(at)cs(dot)uno(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: problem with JDBC connection on gumbo nodes
Date: 2004-12-10 00:49:45
Message-ID: 1467.137.30.122.184.1102639785.squirrel@mailport.cs.uno.edu (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-admin
Hi

I am trying to create a database using JDBC.
I am working in a beowulf cluster, where there is one master node, and
many client nodes.

Right now I want to create JDBC on the master node, and three client nodes.

The postmaster is running on all four of them, the postmaster is using
/tmp/data directory. I modified the ppostgres.conf to set tcpip=true, and
added the ip address to pg_hba.conf file for this to work on the master
node.

But this does not work on the client nodes. i added the ip pf the client
nodes to pg_hba.conf file too. But still it gives me an error as though
there is no IP added:
Error:
----------------------------------------
org.postgresql.util.PSQLException: A connection error has occurred:
org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host
"192.168.1.64", user "kashif", database "gayathkash34"

        at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnectionV3(AbstractJdbc1Connection.java:326)
        at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:213)
        at org.postgresql.Driver.connect(Driver.java:139)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at JavaJdbc.main(JavaJdbc.java:17)

I added the IP: 192.168.1.64 to the pg_hba.conf file.

Could you help with this?

Thanks,
gayatri.




pgsql-admin by date

Next:From: Paulo JobimDate: 2004-12-10 04:41:16
Subject: HELP database files are incompatible with server
Previous:From: Nageshwar RaoDate: 2004-12-09 08:31:24
Subject: runing Postgresql on shared disk

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group