Selective authentication?

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-novice by date

  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