enable SSL on server

Андрей 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)