Documentation → PostgreSQL 7.2

Supported Versions: Current (17) / 16 / 15 / 14 / 13

Development Versions: devel

Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

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.

PostgreSQL 7.2.8 Administrator's Guide

The PostgreSQL Global Development Group

Table of Contents

1. Installation Instructions

1.1. Short Version

1.2. Requirements

1.3. Getting The Source

1.4. If You Are Upgrading

1.5. Installation Procedure

1.6. Post-Installation Setup

1.6.1. Shared Libraries
1.6.2. Environment Variables

1.7. Supported Platforms

2. Installation on Windows

3. Server Runtime Environment

3.1. The PostgreSQL user account

3.2. Creating a database cluster

3.3. Starting the database server

3.3.1. Server Start-up Failures
3.3.2. Client Connection Problems

3.4. Run-time configuration

3.4.1. Planner and Optimizer Tuning
3.4.2. Logging and Debugging
3.4.3. General operation
3.4.4. WAL
3.4.5. Short options

3.5. Managing Kernel Resources

3.5.1. Shared Memory and Semaphores
3.5.2. Resource Limits

3.6. Shutting down the server

3.7. Secure TCP/IP Connections with SSL

3.8. Secure TCP/IP Connections with SSH tunnels

4. Client Authentication

4.1. The pg_hba.conf file

4.2. Authentication methods

4.2.1. Trust authentication
4.2.2. Password authentication
4.2.3. Kerberos authentication
4.2.4. Ident-based authentication

4.3. Authentication problems

5. Localization

5.1. Locale Support

5.1.1. Overview
5.1.2. Benefits
5.1.3. Problems

5.2. Multibyte Support

5.2.1. Enabling Multibyte Support
5.2.2. Setting the Encoding
5.2.3. Automatic encoding translation between server and client
5.2.4. About Unicode
5.2.5. What happens if the translation is not possible?
5.2.6. References
5.2.7. History
5.2.8. WIN1250 on Windows/ODBC

5.3. Single-byte character set recoding

6. Managing Databases

6.1. Creating a Database

6.1.1. Template Databases
6.1.2. Alternative Locations

6.2. Destroying a Database

7. Database Users and Permissions

7.1. Database Users

7.1.1. User attributes

7.2. Groups

7.3. Privileges

7.4. Functions and Triggers

8. Routine Database Maintenance Tasks

8.1. General Discussion

8.2. Routine Vacuuming

8.2.1. Recovering disk space
8.2.2.