Обсуждение: host & hostssl entries in single pg_hba.conf

Поиск
Список
Период
Сортировка

host & hostssl entries in single pg_hba.conf

От
"A.Bhuvaneswaran"
Дата:
Hi,

I am using pgsql 7.3.4 on rh linux 7.3.

I wish to have host & hostssl entries in single pg_hba.conf file. If ssl
is set to true in postgresql.conf, even though we have host entry in
pg_hba.conf, ssl connection is established. Is it a bug or am i doing
something wrong?

Isn't it possible to have host & hostssl entry in single pg_hba.conf ?

TIA.

--
Regards,
A.Bhuvaneswaran
Systems Engineer

Вложения

Re: host & hostssl entries in single pg_hba.conf

От
Tom Lane
Дата:
"A.Bhuvaneswaran" <bhuvan@symonds.net> writes:
> I wish to have host & hostssl entries in single pg_hba.conf file. If ssl
> is set to true in postgresql.conf, even though we have host entry in
> pg_hba.conf, ssl connection is established. Is it a bug or am i doing
> something wrong?

That is the intended behavior.  In 7.4 you can control from the client
side whether libpq will try SSL or non-SSL first, but AFAIR the 7.3
client will always try SSL first if enabled.

            regards, tom lane