By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,660 Members | 1,267 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,660 IT Pros & Developers. It's quick & easy.

Client authentication

P: n/a
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.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.