CRL reloading info - is it refreshed?

Started by Durumdaraover 5 years ago2 messagesgeneral
Jump to latest
#1Durumdara
durumdara@gmail.com

Hello!

For CRL reloading we need to restart the PG In 9.6.

Now we have a new server with 11.x.

As I read it has a reload possibility without restart and dropping the
connections.

SELECT pg_reload_conf();

It's ok. But: the restart is a very good checking point.
If you did it, and after the server is working fine then your config is
good.

What will happen when onfly reload finds something bad (99% of the config
is good, but 1 line in in the config file is wrong)?

And the most important question: how do we know that PG 11 reloaded the
CRL?

Is there any way to get the last full reload timestamp value, or the
version of the actual CRL file, or something like that?

To be sure that we will not have big red error messages on the client's
screen because of invalid CRL?
F. e. it is expired because the reloading failed on something, on a tiny
mistake.

Thank you for every info, help, answer!

Best regards
dd

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Durumdara (#1)
Re: CRL reloading info - is it refreshed?

Durumdara <durumdara@gmail.com> writes:

What will happen when onfly reload finds something bad (99% of the config
is good, but 1 line in in the config file is wrong)?

For a CRL file, the file will be ignored and the old configuration will
remain, I believe.

And the most important question: how do we know that PG 11 reloaded the
CRL?
Is there any way to get the last full reload timestamp value, or the
version of the actual CRL file, or something like that?

There's pg_conf_load_time(), but it doesn't go down to the level of
detail of which specific settings were updated.

The short answer to all these concerns is "after a SIGHUP, look in the
postmaster log to see if there were any complaints".

regards, tom lane