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