Re: cannt setup postgresql database for my opennms - Mailing list pgsql-general

"=?utf-8?B?5p6X6bub546J?=" <blackjadelin@gmail.com> writes:
> Exception in thread "main" org.postgresql.util.PSQLException:
> Connection refused. Check that the hostname and port are correct and
> that the postmaster is accepting TCP/IP connections.

> i have just now checked my postgre with command "netstat -anp | grep
> "post"" and they are right:
> udp        0      0 127.0.0.1:32968         127.0.0.1:32968
> ESTABLISHED 5850/postmaster
> unix  2      [ ACC ]     STREAM     LISTENING     123166
> 5850/postmaster     /tmp/.s.PGSQL.5432
> why dont my opennms setup datebase successfully on my postgresql?

I believe Java requires a TCP connection to postgres; you appear to not
have enabled TCP connections.  You'll need to adjust the postmaster's
listen_addresses or tcpip_socket setting (depending on what PG version
this is) and restart it.

            regards, tom lane