pgsql: Allow full SSL certificate verification (wherein libpq checks its - Mailing list pgsql-committers

Log Message:
-----------
Allow full SSL certificate verification (wherein libpq checks its host name
parameter against server cert's CN field) to succeed in the case where
both host and hostaddr are specified.  As with the existing precedents
for Kerberos, GSSAPI, SSPI, it is the calling application's responsibility
that host and hostaddr match up --- we just use the host name as given.
Per bug #5559 from Christopher Head.

In passing, make the error handling and messages for the no-host-name-given
failure more consistent among these four cases, and correct a lie in the
documentation: we don't attempt to reverse-lookup host from hostaddr
if host is missing.

Back-patch to 8.4 where SSL cert verification was introduced.

Tags:
----
REL8_4_STABLE

Modified Files:
--------------
    pgsql/doc/src/sgml:
        libpq.sgml (r1.289.2.2 -> r1.289.2.3)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/libpq.sgml?r1=1.289.2.2&r2=1.289.2.3)
    pgsql/src/interfaces/libpq:
        fe-auth.c (r1.142.2.1 -> r1.142.2.2)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/libpq/fe-auth.c?r1=1.142.2.1&r2=1.142.2.2)
        fe-secure.c (r1.127.2.2 -> r1.127.2.3)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/libpq/fe-secure.c?r1=1.127.2.2&r2=1.127.2.3)
        libpq-int.h (r1.143 -> r1.143.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/libpq/libpq-int.h?r1=1.143&r2=1.143.2.1)