About SSL connection

From: John Mikel <blpmftat(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: About SSL connection
Date: 2019-01-06 14:10:56
Message-ID: CAAC-7YD8BJ3EJiTO3XpW=kafroi7cYrVU1MsUjyPQgKvY95P5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 }

on https://www.postgresql.org/docs/10/sql-altersystem.html
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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thiemo Kellner 2019-01-06 14:34:19 Is it impolite to dump a message
Previous Message rihad 2019-01-06 08:08:55 Adding new collations after pg_upgrade?