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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
> 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?


> 3.  What is the difference in the following two lines?
> host     all    password
> host     all      password

"One of these things is not like the others ...."

This is basic TCP/IP networking know-how.  The Netmask (
 defines the range of addresses covered.  
Line 1 covers only the single address
Line 2 covers to

Got it?


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-2017 The PostgreSQL Global Development Group