Connections can be prevented in a number of ways, as follows:
- Pause and resume the session pool. See the Setting up a connection pool recipe later in this chapter on controlling connection pools.
- Stop the server! See the Stopping the server safely and quickly and Stopping the server in an emergency recipes, but this is not recommended.
- Restrict the connections for a specific database to zero, by setting the connection limit to zero:
ALTER DATABASE foo_db CONNECTION LIMIT 0;
- This will limit normal users from connecting to that database, though it will still allow superuser connections.
- Restrict the connections for a specific user to zero by setting the connection limit to zero (see the Restricting users to only one session ...