PostgreSQL 12 High Availability Cookbook - Third Edition

How it works...

The first and simplest query merely identifies the name and value for each parameter, which may only be modified by restarting PostgreSQL. In relation to all of the available settings, this list is relatively short. However, there are a few notable settings that could affect us.

We already mentioned wal_level, shared_buffers, max_connections, and max_wal_senders in another recipe. However, this list also includes parameters related to Secure Sockets Layer (SSL) and WAL archiving. We will eventually discuss WAL archiving separately, so that leaves SSL. When provisioning a secure PostgreSQL server that encrypts connection traffic, we require a host SSL certificate. If this certificate is ever compromised, we need to regenerate ...