Unsupported versions: 7.0 / 6.5 / 6.4
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

Chapter 21. Runtime Environment

This chapter outlines the interaction between Postgres and the operating system.

Using Postgres from Unix

All Postgres commands that are executed directly from a Unix shell are found in the directory “.../bin”. Including this directory in your search path will make executing the commands easier.

A collection of system catalogs exist at each site. These include a class (pg_user) that contains an instance for each valid Postgres user. The instance specifies a set of Postgres privileges, such as the ability to act as Postgres super-user, the ability to create/destroy databases, and the ability to update the system catalogs. A Unix user cannot do anything with Postgres until an appropriate instance is installed in this class. Further information on the system catalogs is available by running queries on the appropriate classes.