Thread: two databases

two databases

From
Jodi Kanter
Date:
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


 

 

 

Re: two databases

From
"Nick Fankhauser"
Date:
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







Re: two databases

From
Jean-Michel POURE
Date:
Le Mardi 28 Mai 2002 22:09, Jodi Kanter a écrit :
> 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

Please note that the stable version of PostgreSQL is 7.2.1.

Documentation can be found at:
- http://www.postgresql.org/idocs -> standard documentation
- http://techdocs.postgresql.org -> technical notes
- http://pgadmin.postgresql.org -> pgAdmin2 interface

Cheers,
Jean-Michel POURE