From: John Collins <jcollins@cs.umn.edu>
To: pgsql-interfaces@postgresql.org
Cc: Lamar Owen <lamar.owen@wgcr.org>
Subject: Re: [INTERFACES] JDBC connection refused
Date: Fri, 03 Mar 2000 11:41:10 -0600
Message-ID: <38BFF936.7B9E432A@cs.umn.edu> (raw)
References: <38BFD763.89351A86@cs.umn.edu>
<38BFE863.85A66522@wgcr.org>
Lamar Owen wrote:
> John Collins wrote:
> > - postmaster is indeed being run with the -i flag. I think neither the
> > local jdbc or the remote pgaccess would work otherwise. Here's the line
> > from rc.d/init.d/postgres:
> > su -l postgres -c '/usr/bin/postmaster -i -S -D/var/lib/pgsql'
> > - I've used every name I can think of, including the ip address, in the
> > URL above. I've used the port and I've not used the port.
> > - I've used netstat to check that postmaster is indeed listening on
> > 5432
> >
> > I'm stumped. Thanks in advance for any assistance.
>
> Is there a line in PGDATA/pg_hba.conf allowing access to the remote
> client?
>
> PGDATA on the RPM installation that shipped with RedHat 6.1 is
> /var/lib/pgsql, BTW.
Here's the tail end of the file /var/lib/pgsql/pg_hba.conf. I've restarted
twice since setting this info, using /etc/rc.d/init.d/postgresql restart.
Then I tried a stop and a start just for good measure. The machines I'm
trying to connect from are both 192.168.2.x. Did I get this right?
------------------
# By default, allow anything over UNIX domain sockets and localhost.
local all trust
host all 127.0.0.1 255.255.255.255 trust
host all 192.168.2.0 255.255.255.0 trust
------------------
Thanks for your help.
John Collins
University of Minnesota
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jcollins@cs.umn.edu, lamar.owen@wgcr.org
Subject: Re: [INTERFACES] JDBC connection refused
In-Reply-To: <38BFF936.7B9E432A@cs.umn.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox