Re: About SSL connection

On 1/6/19 8:10 AM, John Mikel wrote:
>
> 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.

What errors in the log files?

--
Angular momentum makes the world go 'round.