View Single Post

   
  #2 (permalink)  
Old 04-16-2008, 12:54 AM
Mark Lewis
 
Posts: n/a
Default Re: Postgres-JDBC question

This usually means that you have allowed TCP/IP connections in
postgresql.conf, but haven't added a rule allowing remote access in
pg_hba.conf for anything other than localhost.

A sample pg_hba.conf line to allow any host on the network to connect
using MD5 password hashes would be:

host all all 0.0.0.0 0.0.0.0 md5

-- Mark Lewis

On Fri, 2006-01-27 at 08:31 -0600, Sean wrote:
> I am using Hibernate to connect to my PostgreSQL (btw – I love)
> database, and can connect my app and the db when using localhost, but
> when I try to connect via an ip address, it blows up telling me that
> the connection was refused. I have set the postmaster to listen for
> TCP/IP connections, but still does not work. Any suggestions?
>
>
>
> Thanks,
>
> Sean
>
>


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply With Quote