Обсуждение: [ADMIN] Restart PostgreSQL service with SSL and private key pass phrase
Hi,
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. So I tried using pg_ctl to start Postgres, but I have few issues:
- 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.
- After running the following command:
pg_ctl -D "c:\Program Files\PostgreSQL\9.5\data" restart -w
I was able to enter the PEM pass phrase since I got a prompt and was able to connect. But when my application is trying to establish the connection with Postgresql, the application is waiting since there are prompts on the command windows where I executed the pg_ctl command to enter the PEM pass phrase. I think this makes the application totally unusable.
- 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.
Please advise on how to achieve what I am doing or share any alternatives that someone already has for this situation.
Thank you
Sent from Mail for Windows 10
Hi,
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. So I tried using pg_ctl to start Postgres, but I have few issues:
- 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.
- After running the following command:
pg_ctl -D "c:\Program Files\PostgreSQL\9.5\data" restart -w
I was able to enter the PEM pass phrase since I got a prompt and was able to connect. But when my application is trying to establish the connection with Postgresql, the application is waiting since there are prompts on the command windows where I executed the pg_ctl command to enter the PEM pass phrase. I think this makes the application totally unusable.
- 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.
Please advise on how to achieve what I am doing or share any alternatives that someone already has for this situation.
Thank you
Sent from Mail for Windows 10
sri bhav wrote: > I currently have PostgreSQL 9.5 installed on a Windows 10 machine. I have enabled SSL and configured key & crt files withpass 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Hi All, Yes, I know I can google and find some tutorials. But not allway fited for newbies. So what I need are steps to install and add PL/java as extention to my PostgresSQL 9.6 server. Thanks lot for your help. koff