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

Chapter 4. Server Control

In this chapter, we will cover the following:

  • Starting the database server manually
  • Stopping the server quickly and safely
  • Stopping the server in an emergency
  • Reloading the server configuration files
  • Restarting the server quickly
  • Preventing new connections
  • Restricting users to just one session each
  • Pushing users off the system
  • Deciding on a design for multi-tenancy
  • Using multiple schemas
  • Giving users their own private database
  • Running multiple database servers on one system
  • Setting up a connection pool

Introduction

PostgreSQL consists of a set of server processes, the group leader of which is named the postmaster. Starting the server is the act of creating these processes, and stopping the server means to terminate those processes. ...

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