O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Updating the parameter file

The parameter file is the main location for defining parameter values for the PostgreSQL server. All of the parameters can be set in the parameter file, which is known as the 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 cover them in the appropriate chapters that follow.

Getting ready

First, locate the postgresql.conf as described earlier.

How to do it...

All of the parameters can be set in the parameter file, which is known as the postgresql.conf. Some of the parameters take effect only when the server is first started. A typical example might be shared_buffers, which defines the size of the shared memory cache.

Many of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required