Mohan, this has got nothing to do with the ssl cert, but is the default configured in pg_hba.conf. See http://www.postgresql.org/docs/8.2/interactive/client-authentication.html for details. In particular, if you want password based authentication, change "ident" to "md5".
As for your SSL problem, the directory permissions are fine. Can you please give the output of
id postgres
? Is it in the ssl-cert group?
Mohan, this has got nothing to do with the ssl cert, but is the default configured in pg_hba.conf. See http:// www.postgresql. org/docs/ 8.2/interactive /client- authentication. html for details. In particular, if you want password based authentication, change "ident" to "md5".
As for your SSL problem, the directory permissions are fine. Can you please give the output of
id postgres
? Is it in the ssl-cert group?