| From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
|---|---|
| To: | Claudio Lapidus <clapidus(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Client authentication |
| Date: | 2003-09-25 22:39:27 |
| Message-ID: | Pine.LNX.4.21.0309252337470.20483-100000@ponder.fairway2k.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-09-25 22:49:49 | Re: MySQL-to-PostgreSQL |
| Previous Message | Claudio Lapidus | 2003-09-25 22:24:27 | Client authentication |