Updating the parameter file

The parameter file is the main location 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 the appropriate chapters that follow.

Getting ready

First, locate postgresql.conf, as described earlier.

How to do it...

Some of the parameters take effect only when the server is first started. A typical example...