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? -- /etc/ssl/private/ssl-cert-snakeoil.key is world readable https://bugs.launchpad.net/bugs/225125 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs