Re: SSL enabled connection for PostgreSQL

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Monday, June 5, 2023, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Monday, June 5, 2023, Rajeshwar Singh <singh.rajeshwar@xxxxxxxxx> 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?

Never mind, you are asking about the client…though the server config itself still seems incorrect.

David J.