In this chapter, we will cover the following recipes:

  • Reading the fine manual
  • Planning a new database
  • Changing parameters in your programs
  • Finding the current configuration settings
  • Which parameters are at non-default 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

Get PostgreSQL Administration Cookbook, 9.5/9.6 Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.