Thread: enable SSL on server
Hello!
Please tell - how to enable SSL on PostgreSQL 8.1 server. When
setting option "ssl = on" in postgresql.conf - server even doesn't want
to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed from
.msi, downloaded from www.posgtresql.org.
Best regards,
Kovalevski Andrei,
soft@andrei.in.ua
Андрей wrote: > Hello! > > Please tell - how to enable SSL on PostgreSQL 8.1 server. When > setting option "ssl = on" in postgresql.conf - server even doesn't want > to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed from > .msi, downloaded from www.posgtresql.org. If the server isn't starting up, it will say why in the logs. What does it say in the logs? -- Richard Huxton Archonet Ltd
Richard Huxton wrote:
> Andrei wrote:
>
>> Hello!
>>
>> Please tell - how to enable SSL on PostgreSQL 8.1 server. When
>> setting option "ssl = on" in postgresql.conf - server even doesn't
>> want to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed
>> from .msi, downloaded from www.posgtresql.org.
>
>
> If the server isn't starting up, it will say why in the logs.
>
> What does it say in the logs?
No logs appear, just got MessageBox with 'PostgreSQL Tray' - 'Service
command failed'. :(
Best Regards,
Kovalevski Andrei
Андрей wrote: > Richard Huxton wrote: > >> Andrei wrote: >> >>> Hello! >>> >>> Please tell - how to enable SSL on PostgreSQL 8.1 server. When >>> setting option "ssl = on" in postgresql.conf - server even doesn't >>> want to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed >>> from .msi, downloaded from www.posgtresql.org. >> >> >> If the server isn't starting up, it will say why in the logs. >> >> What does it say in the logs? > > No logs appear, just got MessageBox with 'PostgreSQL Tray' - 'Service > command failed'. :( It seems unlikely that *nothing* is being logged - PG is usually good at that. Check your logging configuration settings, and see what you get with ssl = false, then try again with ssl = true. If you genuinely have nothing being logged, the failure must be very early in the startup sequence. Try starting it from a command-prompt - you should see an error message then. -- Richard Huxton Archonet Ltd
=?UTF-8?B?0JDQvdC00YDQtdC5?= <andyk@softwarium.net> writes: > Please tell - how to enable SSL on PostgreSQL 8.1 server. When > setting option "ssl = on" in postgresql.conf - server even doesn't want > to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed from > .msi, downloaded from www.posgtresql.org. Did you set up the key and certificate files required by an SSL server? See the documentation: http://www.postgresql.org/docs/8.1/static/ssl-tcp.html regards, tom lane
****************************************************************** * Do not Cc: me, because I am on THIS list, if I write here * * Keine Cc: am mich, bin auf DIESER Liste wenn ich hier schreibe * ****************************************************************** Hello, are the certificates on teh right place? If not, pgsql will not show any errors about it. I think, this should be done in the default loglevel. I had the same problem some weeks ago. Greetings Michelle Am 2005-12-15 14:03:15, schrieb ????????????: > Hello! > > Please tell - how to enable SSL on PostgreSQL 8.1 server. When > setting option "ssl = on" in postgresql.conf - server even doesn't want > to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed from > .msi, downloaded from www.posgtresql.org. > > Best regards, > > Kovalevski Andrei, > soft@andrei.in.ua > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings ------------------------- END OF REPLYED MESSAGE ------------------------- -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)