Unix Technical Forum

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

This is a discussion on BUG #1413: pg_hba.conf : 192.168.2.0/32 not honoured within the pgsql Bugs forums, part of the PostgreSQL category; --> The following bug has been logged online: Bug reference: 1413 Logged by: jerome celle Email address: j.celle@laposte.net PostgreSQL version: ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Bugs

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 08:28 AM
jerome celle
 
Posts: n/a
Default BUG #1413: pg_hba.conf : 192.168.2.0/32 not honoured


The following bug has been logged online:

Bug reference: 1413
Logged by: jerome celle
Email address: j.celle@laposte.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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-10-2008, 08:28 AM
Kris Jurka
 
Posts: n/a
Default Re: BUG #1413: pg_hba.conf : 192.168.2.0/32 not honoured



On Wed, 19 Jan 2005, jerome celle wrote:

> 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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:33 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com