Re: [GENERAL] PAM implementation in PG 9.2.3

2013-05-13 Thread Raghavendra
On Mon, May 13, 2013 at 11:17 AM, Amit Langote wrote: > > However, PG documentation doesn't highlight about this in psql or PAM > > section, because log entries written are slightly confusing. > > http://www.postgresql.org/docs/9.2/static/auth-methods.html > > http://www.postgresql.org/docs/9.2/st

Re: [GENERAL] PAM implementation in PG 9.2.3

2013-05-12 Thread Amit Langote
> However, PG documentation doesn't highlight about this in psql or PAM > section, because log entries written are slightly confusing. > http://www.postgresql.org/docs/9.2/static/auth-methods.html > http://www.postgresql.org/docs/9.2/static/app-psql.html It turns out this logging is a bug in PAM a

Re: [GENERAL] PAM implementation in PG 9.2.3

2013-05-08 Thread Raghavendra
On Wed, May 8, 2013 at 4:55 PM, Amit Langote wrote: > Hello Raghavendra, > > I think probably psql is a problem here. WIthout -W (force password > before connect) option psql has no way knowing if this user needs a > password to connect to the given database. So, psql first attempts a > connection

Re: [GENERAL] PAM implementation in PG 9.2.3

2013-05-08 Thread Amit Langote
Hello Raghavendra, I think probably psql is a problem here. WIthout -W (force password before connect) option psql has no way knowing if this user needs a password to connect to the given database. So, psql first attempts a connection to the database without a password (if -W is not specified), wh

[GENERAL] PAM implementation in PG 9.2.3

2013-05-07 Thread Raghavendra
Hi All, I am trying to implement PAM on my local machine. Below are the details of my setup: OS: RHEL 6 PG: 9.2.3 /etc/pam.d/postgresql (PAM file) #%PAM-1.0 authrequiredpam_unix.so account requiredpam_unix.so $PGDATA/pg_hba.conf # TYPE DATABASEUS