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/