Re: two databases - Mailing list pgsql-admin

From Nick Fankhauser
Subject Re: two databases
Date
Msg-id NEBBLAAHGLEEPCGOBHDGMEJNFAAA.nickf@ontko.com
Whole thread Raw
In response to two databases  (Jodi Kanter <jkanter@virginia.edu>)
List pgsql-admin
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







pgsql-admin by date:

Previous
From: Don Saxton
Date:
Subject: FATAL 1: Database "template0" is not currently accepting connections?
Next
From: Jean-Michel POURE
Date:
Subject: Re: two databases