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 ...
Get PostgreSQL 9 Administration Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.