I have configured my postgresql fonfigure files, postgresql.conf: ...... tcpip_socket = true ssl = true ...... pg_hba.conf: ...... local all trust host all trust ...... and i restart my computer, then i try again to let opennms connect to postgresql, but the same error once more, so nice fuzzy
Tom Lane wrote: > "林黛玉" < 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend