Re: [ADMIN] Postgres and PAM config issues

[Tomasz Myrta]

Marcin Porwit napisal 2007-08-10 03:26:

       positionwhile[pg]% more /etc/pam.d/postgresql
       #%PAM-1.0
       auth       required     pam_stack.so service=system-auth

The system is a CentOS 4.4 box, and I'm running PostgreSQL 8.0.6.

However, when I try to get psql to do password authentication, I get the
following:
        positionwhile[postgresql-8.0.13]% psql authtest
        Password:
        psql: FATAL:  PAM authentication failed for user "mporwit"

Probably you are missing "account" section in your pam configuration.

Regards,
Tomasz Myrta

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings