Database Reference
In-Depth Information
4
Server Control
In this chapter, we will cover the following:
F
Starting the database server manually
F
Stopping the server quickly and safely
F
Stopping the server in an emergency
F
Reloading the server configuration files
F
Restarting the server quickly
F
Preventing new connections
F
Restricting users to just one session each
F
Pushing users off the system
F
Deciding on a design for multi-tenancy
F
Using multiple schemas
F
Giving users their own private database
F
Running multiple database servers on one system
F
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.
Each postmaster listens for client connection requests on one defined port number. Multiple
concurrently running postmasters cannot share that port number. The port number is often
used to identify a particular postmaster uniquely, and so also the database server that it leads.
