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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster