two databases

From: Jodi Kanter <jkanter(at)virginia(dot)edu>
To: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: two databases
Date: 2002-05-28 20:09:10
Message-ID: 016e01c20683$87b16eb0$de138f80@virginia.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)virginia(dot)edu

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Don Saxton 2002-05-28 21:07:55 FATAL 1: Database "template0" is not currently accepting connections?
Previous Message Dmitry Morozovsky 2002-05-28 17:04:09 Re: databases and RAID ...