| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | sri bhav <sri_bhav(at)hotmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Restart PostgreSQL service with SSL and private key pass phrase |
| Date: | 2017-11-20 14:12:56 |
| Message-ID: | 1511187176.2615.22.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
sri bhav wrote:
> I currently have PostgreSQL 9.5 installed on a Windows 10 machine. I have enabled SSL and configured key & crt files with pass phrase.
> I know that I have to enter the PEM pass phrase everytime I try to restart.
> Since I installed Postgres as Windows service, running pg_ctl does not start my service.
> I see postgresql exe instances running in Task manager but my windows service never gets updated to Running.
> Per our security requirements, we cannot remove the PEM pass phrase, so how do I control the PostgreSQL
> service – start & restart with the pass phrase and without user interaction.
Change the security requirements.
What good is a password on a key if you have to store it on the machine
anyway to allow automatic start of the PostgreSQL server?
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2017-11-20 14:33:05 | Migration to pglister - Before |
| Previous Message | Bear Giles | 2017-11-20 13:56:06 | Re: Restart PostgreSQL service with SSL and private key pass phrase |