David,
> 1. Can I have entries in pg_hba.conf for specific databases and then
> end
> with an entry for all so that I can protect certain databases one way
> and
> all the rest another way? For example:
According to the docs, yes. I haven't tried it, though.
> 2. What happens if I have an entry for a specific TCP/IP address
> will it
> take that over the general address?
No.
> 3. What is the difference in the following two lines?
>
> host all 192.168.34.0 255.255.255.255 password
> host all 192.168.34.0 255.255.255.0 password
"One of these things is not like the others ...."
This is basic TCP/IP networking know-how. The Netmask (255.255.255.0)
defines the range of addresses covered.
Line 1 covers only the single address 192.168.34.0
Line 2 covers 192.168.34.0 to 192.168.34.255
Got it?
-Josh
P.S. As of 7.2, you may have to re-start the database server to make
your pg_hba.conf changes take effect.
