Search Postgresql Archives

Re: About SSL connection

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux