From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | 林黛玉 <blackjadelin(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: cannt setup postgresql database for my opennms |
Date: | 2006-09-27 19:11:09 |
Message-ID: | 5508.1159384269@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"=?utf-8?B?5p6X6bub546J?=" <blackjadelin(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2006-09-27 19:12:09 | Re: [HACKERS] PostgreSQL HA questions |
Previous Message | Scott Marlowe | 2006-09-27 19:06:52 | Re: What is the Best Postgresql Load Balancing Solution |