Thread: Client authentication

Client authentication

From
"Claudio Lapidus"
Date:
Hello

We need to deny access to the database for regular users, while allowing
access to admins and a variety of application scripts.

If we use passwords, everything is fine while interactive, but could not
devise a way for scripts to handle them.

We also tried to set up ident authentication, but Solaris is having a hard
time managing this.

Any hints as to how could this be done?

TIA
cl.

Re: Client authentication

From
"Nigel J. Andrews"
Date:
On Thu, 25 Sep 2003, Claudio Lapidus wrote:

> Hello
>
> We need to deny access to the database for regular users, while allowing
> access to admins and a variety of application scripts.
>
> If we use passwords, everything is fine while interactive, but could not
> devise a way for scripts to handle them.
>
> We also tried to set up ident authentication, but Solaris is having a hard
> time managing this.
>
> Any hints as to how could this be done?

Create a ~/.pgpass file for your admins and users the applications run as, if
you're using 7.3. Anything less and I think you would have to use environment
variables (PGUSER and PGPASS?) instead.


--
Nigel Andrews