Major newbie - Part deux

From: "David J(dot) Lines" <dlines(at)principia(dot)edu>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Major newbie - Part deux
Date: 2002-02-26 22:48:38
Message-ID: 3.0.5.32.20020226164838.00c532b0@mail.prin.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

Thank you to Oliver for that help with my password questions. I have a
couple more questions:

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:

local xyz_db password
host xyz_db 127.0.0.1 255.255.255.255 password
local all trust
host all 127.0.0.1 255.255.255.255 trust

In theory I want to protect xyz_db with passwords, but all other databases
I will trust anyone who is local or is on a TCP/IP host.

2. What happens if I have an entry for a specific TCP/IP address will it
take that over the general address?

host all 127.0.0.1 255.255.255.255 trust
host all 192.168.90.0 255.255.255.255 password

Will this require a password from anyone on the 192.168.90.0 addresses, but
all other TCP/IP addresses will be trusted?

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

(and please don't say that there is a 0 in one entry and a 255 in the other
:))

TIA,

David

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Patrick Hatcher 2002-02-26 22:59:41 Re: COPY from on date field problem
Previous Message Patrick Hatcher 2002-02-26 22:46:18 COPY from on date field problem