Jodi-
I've not actually tried this, but here is how I think you could set up a
division such as you describe:
Create two password files with pg_passwd.
Edit pg_hba.conf to specify a different password file for each database:
local database1 password passwords1
local database2 password passwords2
The lines above assume that you've got two databases, "database1" &
"database2", with two corresponding password files, "password1" &
"password2". It also assumes that your database is on the same machine as
the users. If the database is on a different machine, you'd want to add the
IP address(es) & mask & change local to host.
-Nick
--------------------------------------------------------------------------
Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Jodi Kanter
Sent: Tuesday, May 28, 2002 3:09 PM
To: Postgres Admin List
Subject: [ADMIN] two databases
I'd like to set up two databases on one server but need information on
securing them separately. The databases will be accessed by different
groups, who cannot have access to the data on the other database. I assume
that this can be done using Postgres 7.1.3. Am I correct? The database that
I currently have setup is enforcing sign-on using the pg_passwd utility.
Would I just need a separate pg_passwd file for the new database? Do I need
to create a new database cluster area?
Can anyone point to some documentation on the best way to set this up?
suggestions?
Thank you
Jodi
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu