Bob,
> We're running Postgres on a server with 10 workstations (academic computing
lab (RH 8.0, PostgreSQL 7.3.2) ). My question is how do I prevent users from
accessing everyone else's databases. I've read that pg_hba.conf allows all
local users "trust" authentication and cannot seem to get md5 or password to
work as the authentication method. Obviously allowing students global access
is not a good thing.
What do you mean, you can't get md5 or password to work? Can you send a
sample of the lines from the bottom of your pg_hba.conf file?
>
> Also, how can I have each user have an individual database area rather than
all co-located in /usr/share/data.....
See the documentation on CREATE DATABASE.
--
-Josh Berkus
Aglio Database Solutions
San Francisco