Skip site navigation (1) Skip section navigation (2)

RE: [INTERFACES] JDBC connection refused

From: "Joe Shevland" <shevlandj(at)kpi(dot)com(dot)au>
To: "John Collins" <jcollins(at)cs(dot)umn(dot)edu>, <pgsql-interfaces(at)postgreSQL(dot)org>
Cc: "Lamar Owen" <lamar(dot)owen(at)wgcr(dot)org>
Subject: RE: [INTERFACES] JDBC connection refused
Date: 2000-03-04 16:42:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
Unsure if it will help, but try:

> telnet localhost 5432
Connected to localhost.
Escape character is '^]'.

rubbish text I typed.

EInvalid packet lengthConnection closed by foreign host.

But instead try 'birch' or the IP address and see what
you get. But the pg_hba file looks fine as you've got it
I think. Maybe a red herring but check whether there's any
firewalling set up on the server that stops you from connecting.


-----Original Message-----
From: owner-pgsql-interfaces(at)postgreSQL(dot)org
[mailto:owner-pgsql-interfaces(at)postgreSQL(dot)org]On Behalf Of John Collins
Sent: Friday, 3 March 2000 9:41 AM
To: pgsql-interfaces(at)postgreSQL(dot)org
Cc: Lamar Owen
Subject: Re: [INTERFACES] JDBC connection refused

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   trust
host         all     trust

Thanks for your help.

John Collins
University of Minnesota


In response to


pgsql-interfaces by date

Next:From: Stuart HodgkinsonDate: 2000-03-04 20:19:27
Previous:From: Aage J. SkjolingstadDate: 2000-03-04 09:32:07

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group