From: | "David Patricola" <david(dot)patricola(at)jefferson(dot)edu> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | SSL test using psql fails |
Date: | 2011-03-24 20:02:47 |
Message-ID: | 6B3B8C5F396B4E208854B9384FBCCD65@tjumst.jefferson.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I set up server.crt, root.crt and servery.key in postgresql (using
<http://howtoforge.com/postgresql-ssl-certificates>
http://howtoforge.com/postgresql-ssl-certificates for instructions), set ssl
= on and restarted the service successfully.
However, as I test the connection with psql to see if it's running in SSL I
get the following:
-bash-3.2$ psql -h localhost -U dbadmin
psql: could not open certificate file
"/var/lib/pgsql/.postgresql/postgresql.crt": No such file or directory
I have the certificates stores in lib/pgsql/data/, where they should be, so
what's the disconnect between the top example and the following one?
http://jdbc.postgresql.org/documentation/80/ssl.html explains how to test
locally if running in SSL
David Patricola | Senior Cold Fusion Developer | Web Applications & Services
| Jefferson Information Technologies
Thomas Jefferson Universtiy | Philadelphia, PA | 215.503.1715 (Office)
From | Date | Subject | |
---|---|---|---|
Next Message | Lew | 2011-03-26 13:06:09 | Re: Postgresql iPhone |
Previous Message | Antha Lamus | 2011-03-24 19:57:22 | inserting non-printable character in varchar when CLIENT_ENCODING is SQL_ASCII |