On 1/7/19 2:51 AM, John Mikel wrote:
Please reply to list also
Ccing list
Thanks,
after setting the postgresql.conf file nothing changes (ssl = off)
is this a bug or what ?
Did you restart the server?
Per Ron's post what are the error messages in the Postgres and/or system
logs?
how to enable SSL?what you need to that ?
https://www.postgresql.org/docs/10/ssl-tcp.html
Le dim. 6 janv. 2019 à 21:01, Adrian Klaver <adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>> a écrit :
On 1/6/19 6: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
In addition to what Ron said about checking the logs, you could change
the ssl setting back to 'off' in the postgresql.conf file.
>
> 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.
>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
