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

8.0 Beta 4 denying network connections?

From: Vinko Vrsalovic <el(at)vinko(dot)cl>
To: pgsql-general(at)postgresql(dot)org
Subject: 8.0 Beta 4 denying network connections?
Date: 2004-10-30 00:07:07
Message-ID: 20041030000707.GA18200@landsat.cprsig.cl (view raw or flat)
Thread:
Lists: pgsql-general
Hello,

	I've got one 7.4 installation and a brand new 8.0 beta4 
	running on the same machine.

	Both installations are configured to use the same port
	(5431) to avoid reconfiguring the apps running on 
	top of the DB.

	The following paragraphs illustrate the problem:

[root(at)mymachine root 20:52:07]# service postgres74 start                    
Starting PostgreSQL: ok

[vinko(at)mymachine sources 20:54:36]$ telnet mymachine 5431   
Trying 192.168.2.69...
Connected to mymachine.mydomain.cl (192.168.0.169).
Escape character is '^]'.
null
Connection closed by foreign host.

[root(at)mymachine root 20:55:50]# service postgres74 stop
Stopping PostgreSQL: ok
[root(at)mymachine root 20:55:56]# service postgres8 start 
Starting PostgreSQL: ok

[vinko(at)mymachine sources 20:55:07]$ telnet mymachine 5431
Trying 192.168.0.169...
telnet: Unable to connect to remote host: Connection refused

If I try connecting from localhost, I can connect without 
trouble in both versions.

And, of course, the same happens with the psql client.

I tried modifying pg_hba.conf but to no avail and what I have 
looks right to me. 

Has the syntax for this file changed? I even tried to use the 74's 
pg_hba with 80, but the results are the same.

Is there another config option I'm missing? FWIW, beta3 doesn't 
behave this way.

Thanks for any insight on the issue,
-- 
Vinko Vrsalovic <el[|-(at)-|]vinko.cl>

Responses

pgsql-general by date

Next:From: Uwe C. SchroederDate: 2004-10-30 00:37:23
Subject: Re: adding missing FROM-clause
Previous:From: Ed L.Date: 2004-10-29 23:46:16
Subject: can't shrink relation

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