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

Re: No entry to pg_hba.conf 10.17.11.16

From: "Roman Fail" <rfail(at)posportal(dot)com>
To: "Fabiano" <fcostola(at)osite(dot)com(dot)br>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: No entry to pg_hba.conf 10.17.11.16
Date: 2003-03-12 16:00:52
Message-ID: 9B1C77393DED0D4B9DAA1AA1742942DA3BCABA@pos_pdc.posportal.com (view raw or flat)
Thread:
Lists: pgadmin-support
I'm not a TCP/IP networking expert, but I'm pretty certain that 10.x.x.x addresses are the very definition of a private non-routable Class A network.  Which means the subnet mask should be 255.0.0.0.  
 
255.255.255.0 is the mask for Class C networks, which for private networks are generally defined as 192.168.x.x.   
 
The first big question is can you ping the server from another machine on your private network? (Assuming ICMP8 is not blocked by a software firewall).  If you can't ping it, then something is wrong with your network configuration. Are you able to access the server at the specified IP address through other services, such as telnet, ssh, ftp? (assumes that some of those daemons are running on the server)
 
Can the server ping itself?  Does it's ethernet interface even work?  Can it ping other hosts on the network?  Keep asking questions like this and sooner or later you'll have your answer.
 
IP References:
http://www.oreilly.com/catalog/coreprot/chapter/appb.html
http://questy.com/tech/netw62.htm
http://www.sangoma.com/fguide.htm
 
Roman

	>I do not know why the others has "USER" at pg_hba.conf. Maybe your
	>version is 7.3. Mine is 7.2.
	>
	>Thanks for your suggestion but it have not worked. The mask I use is
	>from my local network, and all the stations is with the same mask.
	>
	>I restarted the server many times using pg_ctl restart or stop and then
	>start. I do not know what can I do.
	
	>>>I put the following line at pg_hba.conf:
	>>>
	>>>local all     10.17.11.0      255.255.255.0   trust
	>>>   
	>>>
	>>
	>>Mine has a "user" column, which yours skipped. It would be:
	>>
	>>local all all 10.17.11.0 255.255.255.0 trust
	>>
	>>You must also make sure you restart the server. Try connecting on localhost
	>>or 127.0.0.1.
	>>
	>>PS, are you actually on a Class C network? If you are, then your subnet mask
	>>might be 255.0.0.0, or something else entirely.
	>>
	>>-Keith
	

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2003-03-12 16:10:38
Subject: Re: No entry to pg_hba.conf 10.17.11.16
Previous:From: Erich TitlDate: 2003-03-12 15:27:25
Subject: Info

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