Setting configuration parameters for the database server

The parameter file is the main location that's used for defining parameter values for the PostgreSQL server. All the parameters can be set in the parameter file, which is known as postgresql.conf. There are also two other parameter files: pg_hba.conf and pg_ident.conf. Both of these relate to connections and security, so we'll cover them in later chapters.

Getting ready

In the pg_settings view, the context defines when each parameter can be set. The following table categorizes this so that we can see what action is needed for changes to take effect. SET is a command, but RELOAD and RESTART are actions, not specific commands. What is RESTART ALL? Some parameters marked POSTMASTER are marked as exceptions in the following table. These parameters must be set to a value less than or equal to their setting on standby. As a result, to increase them on the primary, we must first increase...