I don't understand this WARNING on pg_ctl startup

Started by Ralph Smithabout 18 years ago2 messagesgeneral
Jump to latest
#1Ralph Smith
smithrn@washington.edu

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

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
==================================

#2Chris
dmagick@gmail.com
In reply to: Ralph Smith (#1)
Re: I don't understand this WARNING on pg_ctl startup

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/