From: | "blackjadelin" <blackjadelin(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: cannt setup postgresql database for my opennms |
Date: | 2006-09-28 04:02:47 |
Message-ID: | 1159416167.050332.268490@m73g2000cwd.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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:
> "=?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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
From | Date | Subject | |
---|---|---|---|
Next Message | Gene | 2006-09-28 04:21:40 | grant select on all tables of schema or database |
Previous Message | Jonathan Leffler | 2006-09-28 03:53:49 | Re: cyclical redundancy checksum algorithm(s)? |