Обсуждение: I don't understand this WARNING on pg_ctl startup

===============================

postgres@flexo:/usr/lib/postgresql/8.2/bin$ 2008-03-04 15:47:21 PST
LOG:  00000: could not load root certificate file "root.crt": no SSL
error reported
2008-03-04 15:47:21 PST DETAIL:  Will not verify client certificates.
2008-03-04 15:47:21 PST LOCATION:  initialize_SSL, be-secure.c:785

-----

ALSO, when I start PG via
./pg_ctl start -D /var/lib/postgresql/8.2/main
  c/o `ps -ef`  I get:
postgres   872     1  4 15:47 pts/2    00:00:00 /usr/lib/postgresql/
8.2/bin/postgres

whereas at other times I get:
postgres 31784     1  5 15:20 pts/2    00:00:00 /usr/lib/postgresql/
8.2/bin/postgres -D /var/lib/postgresql/8.2/main

Can anyone tell me what that is?


Thank you,
Ralph Smith
==================================

Ralph Smith wrote:
> ===============================
>
> postgres@flexo:/usr/lib/postgresql/8.2/bin$ 2008-03-04 15:47:21 PST
> LOG:  00000: could not load root certificate file "root.crt": no SSL
> error reported
> 2008-03-04 15:47:21 PST DETAIL:  Will not verify client certificates.
> 2008-03-04 15:47:21 PST LOCATION:  initialize_SSL, be-secure.c:785

You have:

ssl = true

in your postgresql.conf file but when postgres tries to start up, there
is no root.crt file (or it can't be read due to permissions).

http://www.postgresql.org/docs/8.2/interactive/ssl-tcp.html

--
Postgresql & php tutorials
http://www.designmagick.com/