From: | harpagornis <shenlong(at)runbox(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | SSL Certificates in Postgres 9.3 and Windows 7 |
Date: | 2014-11-09 04:07:47 |
Message-ID: | 1415506067738-5826230.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am trying to implement SSL certificates with postgres 9.3 locally in
Windows 7. In Windows Component Services / Local Services, postrgres is
configured to start automatically, with Log On as a local system account.
Using my Windows administrator account, in a command prompt inside my data
folder, when I execute postgres -D . , I get the message, "Redirecting
logging output to the logging collector service." I also get this error
message in my log file:
When I try to connect in PgAdminIII I get the error message, "Server isn't
listening" What am I doing wrong? Right now, just for development
purposes, do I need to have a root certificate? I tried unsuccessfully to
create one with makecert but couldn't get the flags and options right.
I followed the postgres & openssl documentation for creating the
privkey.pem, server.req, server.key and server.crt files, ie.:
This is the entire pg_hba.conf file:
Also, which of those last two lines in the pg_hba.conf file should I be
using to require SSL certificates for all postgres accounts? Is it even
possible to require a SSL certificate for the postgres account?
This the entire postgresql.conf file:
Thank you for all comments and suggestions.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/SSL-Certificates-in-Postgres-9-3-and-Windows-7-tp5826230.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Тарас Савчук | 2014-11-09 11:15:35 | BDR, 9.4 release schedule, PostgreSQL in Azure, pgPool-II |
Previous Message | Shaun Thomas | 2014-11-07 17:58:38 | Re: DATA corruption after promoting slave to master |