From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | howardnews(at)selestial(dot)com, Pgsql General <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Could not load server certificate file "server.crt": No such file or directory. |
Date: | 2022-08-12 17:09:11 |
Message-ID: | e8bc2b97-573a-1dd1-a65e-da076e468260@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 8/12/22 10:02 AM, howardnews(at)selestial(dot)com wrote:
> Hi,
>
> Running 14.4.1 on Mac OSX on M1 and found that the postgres daemon had
> not started. It was running fine previously.
>
> When I ran the following command line:
>
> sudo -u postgres /Library/Postgresql/14/bin/postmaster -D
> /Library/Postgresql/14/data
>
> I get the following error:
>
> 2022-08-12 17:47:33.239 BST [896] FATAL: could not load server
> certificate file "server.crt": No such file or directory
>
> Not sure what I have done - but where do I find this file - and can I
> regenerate it easily?
I am guessing you did from here:
https://www.postgresql.org/docs/current/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SSL
"ssl (boolean)
Enables SSL connections. This parameter can only be set in the
postgresql.conf file or on the server command line. The default is off.
"
set ssl on.
Check postgresql.conf to verify. If you don't want SSL on then set to off.
If you want it on and need a certificate see:
https://www.postgresql.org/docs/14/ssl-tcp.html#SSL-CERTIFICATE-CREATION
>
> Thanks,
>
> Howard.
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Korot | 2022-08-12 17:27:16 | Is ODBC list dead? |
Previous Message | howardnews | 2022-08-12 17:02:55 | Could not load server certificate file "server.crt": No such file or directory. |