Thread: 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
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
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