knowledge-database (beta)

Current group: pgsql.bugs

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

BUG #1413: pg_hba.conf : 192.168.2.0/32 not honoured  
jerome celle
 Re: BUG #1413: pg_hba.conf : 192.168.2.0/32 not honoured  
Kris Jurka
From:jerome celle
Subject:BUG #1413: pg_hba.conf : 192.168.2.0/32 not honoured
Date:Wed, 19 Jan 2005 17:13:26 GMT

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
From:Kris Jurka
Subject:Re: BUG #1413: pg_hba.conf : 192.168.2.0/32 not honoured
Date:Thu, 20 Jan 2005 14:32:13 -0500 (EST)


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
   

Copyright © 2006 knowledge-database   -   All rights reserved