From: Tom Lane <tgl@sss.pgh.pa.us>
To: Edwin UY <edwin.uy@gmail.com>
cc: pgsql-admin@lists.postgresql.org
Subject: Re: How to setup startup without asking for a passphrase
In-reply-to: 
 <CA+wokJ-Cs5+ODfMyQpZXG_AyrpMf7-UCfNyhXQghtAxzxv6_Ww@mail.gmail.com>
References: 
 <CA+wokJ-Cs5+ODfMyQpZXG_AyrpMf7-UCfNyhXQghtAxzxv6_Ww@mail.gmail.com>
Comments: In-reply-to Edwin UY <edwin.uy@gmail.com>
	message dated "Tue, 11 Jun 2024 01:49:08 +1200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <729015.1718031485.1@sss.pgh.pa.us>
Date: Mon, 10 Jun 2024 10:58:05 -0400
Message-ID: <729016.1718031485@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/729016.1718031485%40sss.pgh.pa.us>
Precedence: bulk

Edwin UY <edwin.uy@gmail.com> writes:
> For some reason, one of the hosts has started asking for a passphrase when
> we rebooted the server.
> Not sure what has happened for it to start doing so.
> Any chance any one has the answer/fix to get it back to where it doesn't
> ask for a passphrase?

Maybe you installed a new server SSL certificate and forgot to remove
the passphrase from the .crt file?

That's only a guess though, because "asking for a passphrase" is
very vague.  If you need more help, please provide the *exact*
output and the context where it appears.  Also, what PG version
is this and on what platform?

			regards, tom lane