How to enable SSL on client

Поиск
Список
Период
Сортировка
От Rajagopalan, Jayashree
Тема How to enable SSL on client
Дата
Msg-id A7A2044B8A59DA4F9F07599B3B1CA12165F1F8BB@MX101CL02.corp.emc.com
обсуждение исходный текст
Ответы Re: How to enable SSL on client
Re: How to enable SSL on client
Re: How to enable SSL on client
Список pgsql-admin

Hi all:

 

I’m on postgres 9.0.18. Want to enable SSL for the DB connections.

The binaries are build including the openssl.

 

I modified the postgresql.conf – for ssl=on.

Copied the server.crt in the  data folder.

Modified pg_hba.conf  - to add:


“hostssl  all         all        0.0.0.0/0       md5”

 

Getting the following errors in the logs when I start DB:

FATAL:  no pg_hba.conf entry for host "127.0.0.1", user "myuser", database "mydb", SSL off

 

Can someone share the right procedure to enable SSL on client?

I’ve created ~/.posgresql directory and added the client.crt and server.key.

 

Regards

Jayashree

В списке pgsql-admin по дате отправления:

Предыдущее
От: Khangelani Gama
Дата:
Сообщение: Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
Следующее
От: Matthieu Lejeune
Дата:
Сообщение: Problem pg_upgradecluster from 9.1 to 9.3