This chapter describes the available localization features from the point of view of the administrator. PostgreSQL supports two localization facilities: Using the locale features of the operating… Read More »PostgreSQL Localization
Every instance of a running PostgreSQL server manages one or more databases. Databases are therefore the topmost hierarchical level for organizing SQL objects (“database objects”). This chapter describes the… Read More »PostgreSQL Managing Databases
PostgreSQL manages database access permissions using the concept of roles. A role can be thought of as either a database user, or a group of database users,… Read More »PostgreSQL Database Roles
When a client application connects to the database server, it specifies which PostgreSQL database user name it wants to connect as, much the same way one logs… Read More »PostgreSQL Client Authentication
Previous PostgreSQL Versions array_nulls (boolean) This controls whether the array input parser recognizes unquoted NULL as specifying a null array element. By default, this is on, allowing array values… Read More »PostgreSQL Version and Platform Compatibility
Statement Behavior client_min_messages (enum) Controls which message levels are sent to the client. Valid values are DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, LOG, NOTICE, WARNING, and ERROR. Each level includes all the levels that follow it. The later… Read More »PostgreSQL Client Connection Defaults
Where to Log log_destination (string) PostgreSQL supports several methods for logging server messages, including stderr, csvlog and syslog. On Windows, eventlog is also supported. Set this parameter to a list of desired log… Read More »PostgreSQL Error Reporting and Logging
These settings control the behavior of the built-in streaming replication feature. Servers will be either a master or a standby server. Masters can send data, while standbys… Read More »PostgreSQL Replication
There are many configuration parameters that affect the behavior of the database system. In the first section of this chapter we describe how to interact… Read More »PostgreSQL Server Configuration
It is recommended that most users download the binary distribution for Windows, available as a graphical installer package from the PostgreSQL website. Building from source is only… Read More »PostgreSQL Installation on Windows
This chapter describes the installation of PostgreSQL using the source code distribution. If you are installing a pre-packaged distribution, such as an RPM or Debian package, ignore… Read More »PostgreSQL Installation
The physical structure of PostgreSQL is very simple. It consists of shared memory and a few background processes and data files. PostgreSQL structure Shared Memory… Read More »PostgreSQL Architecture