Home > mailing lists

About SSL connection - Mailing list pgsql-general

From	John Mikel
Subject	About SSL connection
Date	January 6, 2019 17:10:56
Msg-id	CAAC-7YD8BJ3EJiTO3XpW=kafroi7cYrVU1MsUjyPQgKvY95P5g@mail.gmail.com Whole thread Raw
Responses	Re: About SSL connection Re: About SSL connection
List	pgsql-general

Hi,

i was trying to enable SSL on postgresql 10 and 11 Servers after searching

on postregsql documentation i found this :

ALTER SYSTEM SET configuration_parameter { TO | = } { value | 'value' | DEFAULT }

i used

ALTER SYSTEM SET SSL = ON , querry executed successfully

after that i entred this Select *  from pg_settings , i saw that ssl value is off,

after  stoping the service of postgresql it wont start again

i tried this on both servers 11 and 10 the same problem (the server wont start again)

I'm using widonws 7 x64.

my question is  how to enbale SSL ?

ps : i created all require cert files.

sorry for my bad english.

From: rihad
Date: 06 January 2019, 11:08:55
Subject: Adding new collations after pg_upgrade?

From: Thiemo Kellner
Date: 06 January 2019, 17:34:19
Subject: Is it impolite to dump a message