Starting the postmaster with a "-i" option did the trick.
-i Allows clients to connect via TCP/IP (Internet domain) connections. Without this
option, only local Unix domain socket connections are accepted. This option corre-
sponds to setting tcpip_socket=true in postgresql.conf.
--tcpip-socket=false has the opposite effect of this option.
However, this still does not solve my problem of having a java application connect to the postgres DB server. I get the following error:
Couldn't connect: print out a stack trace and exit.
org.postgresql.util.PSQLException: A connection error has occurred: org.postgres ql.util.PSQLException: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "b rakesh", database "testing123", SSL off
at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnectionV3(Abstrac tJdbc1Connection.java:337)
at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJ dbc1Connection.java:214)
at org.postgresql.Driver.connect(Driver.java:139)
at java.sql.DriverManager.getConnection(DriverManager.java:559)
at java.sql.DriverManager.getConnection(DriverManager.java:189)
at db_connect_pgsql.main(db_connect_pgsql.java:25)
-Bhavana
Tom Lane wrote:
"Bhavana.Rakesh" <Bhavana.Rakesh@noaa.gov> writes:
Here's what happens when I specify the port number
[brakesh@lnx383 ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123
psql: could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5000?
5000 being a nonstandard port number, it's certainly possible that the
kernel is filtering this connection attempt. "Connection refused" might
mean either that there's no process listening to TCP port 5000, or that
the kernel rejected the connection before looking for a listening process.
In any case it seems highly probable that you do have two postmasters
running on this machine, one at port 5000 and one at port 5432. The
psql calls without an explicit -p switch would have defaulted to port
5432 unless you've done something strange to your installation.
regards, tom lane
