Re: Major newbie - Part deux

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.