> 1. Can I have entries in pg_hba.conf for specific databases and then
> with an entry for all so that I can protect certain databases one way
> 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?
> 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
P.S. As of 7.2, you may have to re-start the database server to make
your pg_hba.conf changes take effect.
In response to
pgsql-novice by date
|Next:||From: denis||Date: 2002-02-27 05:36:52|
|Subject: Re: update|
|Previous:||From: Oliver Elphick||Date: 2002-02-26 23:58:49|
|Subject: Re: COPY from on date field problem|