dbTalk Databases Forums  

[BUGS] BUG #1413: pg_hba.conf : 192.168.2.0/32 not honoured

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1413: pg_hba.conf : 192.168.2.0/32 not honoured in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jerome celle
 
Posts: n/a

Default [BUGS] BUG #1413: pg_hba.conf : 192.168.2.0/32 not honoured - 01-20-2005 , 01:05 PM







The following bug has been logged online:

Bug reference: 1413
Logged by: jerome celle
Email address: j.celle (AT) laposte (DOT) net
PostgreSQL version: 8.0.0
Operating system: Linux Redhat 9
Description: pg_hba.conf : 192.168.2.0/32 not honoured
Details:

With following entry in pg_hba.conf :
host all all 192.168.2.0/32 trust

I get the following error when attempting to open a connection from
192.168.2.27 host :

Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host
"192.168.2.27", user "adeolis", database "adeolis"

NOW, if i change the entry to :
host all all 192.168.2.27/0 trust

I can connect.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply With Quote
  #2  
Old   
Kris Jurka
 
Posts: n/a

Default Re: [BUGS] BUG #1413: pg_hba.conf : 192.168.2.0/32 not honoured - 01-20-2005 , 01:34 PM








On Wed, 19 Jan 2005, jerome celle wrote:

Quote:
With following entry in pg_hba.conf :
host all all 192.168.2.0/32 trust

I get the following error when attempting to open a connection from
192.168.2.27 host :
Perhaps you want 192.168.2.0/24.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.