Re: use SSL TO AUTH

"Fabio Serra" <faserone(at)gmail(dot)com> writes:
> First, I don't understand if PostgreSQL in OpenSuse 10.3 was compiled with
> SSL support. Is there any command to know how was compiled PG ?

Almost certainly it was, but pg_config would show you the configure options.

> I changed to on the ssl option in postgresql.conf and I created a self
> signed certificate that i copied in /var/lib/pgsql/data/
> The problem is that Postgres doesn't start correctly and I can't find any
> log to understand why.

You'd need to look at the start script to see where it's sending the
postmaster log to. The postgresql.conf file might also influence that.
I don't know how OpenSuse's package sets up the logging, but surely
it's going somewhere.

regards, tom lane