Обсуждение: SSL enabled connection for PostgreSQL
Hi...
I am setting up PostgreSQL 14 with SSL and passphrase. The postgresql.conf file has following entry:
ssl=on
.
.
ssl_passphrase_command='passphrase.txt'
ssl_passphrase_command_supports_reloads = on
Now when I try to connect using psql, it ask for Enter PEM pass_phrase:
Is there a way where client can be configured so it doesn't ask for pass phrase ?
Thanks in advance
Rajeshwar Singh
On Monday, June 5, 2023, Rajeshwar Singh <singh.rajeshwar@gmail.com> wrote:
Hi...I am setting up PostgreSQL 14 with SSL and passphrase. The postgresql.conf file has following entry:ssl=on..ssl_passphrase_command='passphrase.txt' ssl_passphrase_command_supports_reloads = on Now when I try to connect using psql, it ask for Enter PEM pass_phrase:Is there a way where client can be configured so it doesn't ask for pass phrase
Go and re-read how ssl_passphrase_command works and then write a command that behaves in a compatible manner?
David J.
On Monday, June 5, 2023, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Monday, June 5, 2023, Rajeshwar Singh <singh.rajeshwar@gmail.com> wrote:Hi...I am setting up PostgreSQL 14 with SSL and passphrase. The postgresql.conf file has following entry:ssl=on..ssl_passphrase_command='passphrase.txt' ssl_passphrase_command_supports_reloads = on Now when I try to connect using psql, it ask for Enter PEM pass_phrase:Is there a way where client can be configured so it doesn't ask for pass phraseGo and re-read how ssl_passphrase_command works and then write a command that behaves in a compatible manner?
Never mind, you are asking about the client…though the server config itself still seems incorrect.
David J.