| From: | <kynn(at)panix(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Selective authentication? |
| Date: | 2005-08-25 19:31:45 |
| Message-ID: | 200508251931.j7PJVj324561@panix3.panix.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I'm setting up PostgreSQL for a small academic lab, where I work. The
host OS is Linux (Debian). I want to allow most users to connect to
the database without having to supply a password, but I want to have a
special user, called dbadmin, with superuser privileges. The idea is
that I (or whoever gets entrusted with this responsibility) would
connect as dbadmin *only* when the task at hand required superuser
privileges.
I'd be very grateful if someone could explain to me how to set this
up.
(If there were a simple way to obviate the need to type in a password
every time (e.g. through a suitable command in a configuration file,
such as one can do with ${HOME}/.my.cnf), then I could just require a
password from everyone, but I have not found out how to do this in
PostgreSQL.)
Many thanks in advance!
kj
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charley L. Tiggs | 2005-08-25 20:10:22 | Re: Selective authentication? |
| Previous Message | operationsengineer1 | 2005-08-25 18:46:13 | Copy Failure |