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.