O'Reilly logo

PostgreSQL 9 Administration Cookbook - Second Edition by Simon Riggs, Gianni Ciolli, Hannu Krosing, Gabriele Bartolini

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

Chapter 3. Configuration

In this chapter, we will cover the following recipes:

  • Reading The Fine Manual (RTFM)
  • Planning a new database
  • Changing parameters in your programs
  • Finding the current configuration settings
  • Which parameters are at nondefault settings?
  • Updating the parameter file
  • Setting parameters for particular groups of users
  • The basic server configuration checklist
  • Adding an external module to PostgreSQL
  • Using an installed module
  • Managing installed extensions

Introduction

I get asked many questions about parameter settings in PostgreSQL. Everybody's busy and most people want a 5-minute tour of how things work. That's exactly what a Cookbook does, so we'll do our best.

Some people believe that there are some magical parameter settings that will improve ...

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