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.
[mailto:owner-pgsql-interfaces(at)postgreSQL(dot)org]On Behalf Of John Collins
Sent: Friday, 3 March 2000 9:41 AM
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
> 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.
University of Minnesota
In response to
pgsql-interfaces by date
|Next:||From: Stuart Hodgkinson||Date: 2000-03-04 20:19:27|
|Previous:||From: Aage J. Skjolingstad||Date: 2000-03-04 09:32:07|
|Subject: Re: [INTERFACES] ODBC|