Unexpected behavior from using default config value - Mailing list pgsql-bugs

From Yongqian Li
Subject Unexpected behavior from using default config value
Date
Msg-id CAKF_vo5gXBvqji6JcWNcK9VmBx=3vFC32pUBKgXCnntyQ7y8hw@mail.gmail.com
Whole thread Raw
Responses Re: Unexpected behavior from using default config value  ("Euler Taveira" <euler@eulerto.com>)
Re: Unexpected behavior from using default config value  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
I encountered this problem while I was trying to enable SSL on my postgresql server. Since I was satisfied with the default values for the "ssl_key_file" and "ssl_cert_file" settings I chose to not configure them -- I simply turned on "ssl" and copied over the files to the default locations. However, I kept getting certificate errors on the client. Examining the certificate sent by the server using `openssl s_client -starttls postgres -connect "$HOSTNAME:5432"` revealed that the server was sending some auto-generated cert instead of the one in "server.crt". Setting the "ssl_key_file" and "ssl_cert_file" settings explicitly to their default value fixed the problem. From the documentation I would expect that missing values for config keys would fallback to their default value; instead it seems that postgresql has some undocumented fallback behavior in this case.

pgsql-bugs by date:

Previous
From: Alexander Lakhin
Date:
Subject: Re: BUG #17161: Assert failed on opening a relation that exists in two schemas via the LANGUAGE SQL function
Next
From: Andrey Borodin
Date:
Subject: Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data