Discussion:
Using CIDR and md5 in pg_hba.conf
(too old to reply)
Bender, Cheryl
2004-06-10 20:36:07 UTC
Permalink
Hello all;

I am trying to connect to a postgreSQL server running version 7.3.2 on
freebsd (5.1). I'm having trouble getting the syntax right for this
subnet. I thought I had this working at home for a simple
192.168.0.0/24 network. This is the line in the pg_hba.conf

host all all 10.16.0.0/12 trust

I restarted the server each time I make a change to the file but get
error "missing or erroneous pg_hba.conf file"

I can connect fine as long as I put only my IP and netmask in. I went
on the internet to make sure I have the right subnet and CIDR, so I
think it's correct. My server at home is running an older version
(7.1.?3) so perhaps something has changed, but I can't help but think
that I'm having a brain cramp here. Any hints would be most welcome.

Cheryl Bender


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
Tom Lane
2004-06-10 21:20:56 UTC
Permalink
Post by Bender, Cheryl
I am trying to connect to a postgreSQL server running version 7.3.2 on
freebsd (5.1). I'm having trouble getting the syntax right for this
subnet. I thought I had this working at home for a simple
192.168.0.0/24 network. This is the line in the pg_hba.conf
host all all 10.16.0.0/12 trust
I don't think 7.3 accepted the /n syntax for netmask.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org
Loading...