Skip site navigation (1) Skip section navigation (2)

Re: Major newbie - Part deux

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "David J(dot) Lines" <dlines(at)principia(dot)edu>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: Major newbie - Part deux
Date: 2002-02-27 00:34:01
Message-ID: web-811065@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.

In response to

pgsql-novice by date

Next:From: denisDate: 2002-02-27 05:36:52
Subject: Re: update
Previous:From: Oliver ElphickDate: 2002-02-26 23:58:49
Subject: Re: COPY from on date field problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group