Admin questions - Mailing list pgsql-general

From John Rodriguez
Subject Admin questions
Date
Msg-id 3C4861BC.BC0DE19A@columbia.edu
Whole thread Raw
List pgsql-general
I installed Postgres 7.1 client and server on my Redhat 7.2 box

I only allow SSH connections and I want to set up accounts for the users

of my box.
The only client that will connect to this database will be the one
installed on my box.
(They will SSH into the box, then log on to psql..that sounds, right?)

How do I set it up so that the PostgreSQL accounts have the same names
and passwords as the
home accounts on the OS?  Is this possible?

Furthermore, if I have applications (JSP, Perl, etc) that query this
database, will there be conflicts?
Do I create a www user in this case for PostgreSQL stored procedure exec

privileges?

Thanks.


pgsql-general by date:

Previous
From: "Harald Armin Massa"
Date:
Subject: Different views with same name for different users
Next
From: georgy_zhukov@hotmail.com (Georgy Zhukov)
Date:
Subject: Postgresql monitoring question