From: | "Jeffrey Webster" <icwebby(at)gmail(dot)com> |
---|---|
To: | blackjadelin <blackjadelin(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: cannt setup postgresql database for my opennms |
Date: | 2006-10-01 02:41:05 |
Message-ID: | 8c0cc2820609301941i5cf4daav60169663d5019339@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hopefully your pg_hba.conf files look more like:
local all all trust
host all all 192.168.10.0/24 trust
host pgbench all 192.168.3.0/24 trust
On 27 Sep 2006 21:02:47 -0700, blackjadelin <blackjadelin(at)gmail(dot)com> wrote:
>
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Bauer | 2006-10-01 06:29:09 | Major Performance decrease after some hours |
Previous Message | Jonathan Vanasco | 2006-09-30 23:32:56 | Re: memory issues when running with mod_perl |