PostgreSQL Administrator's Guide

The PostgreSQL Development Team

Edited by

Thomas Lockhart

PostgreSQL is Copyright © 1996-9 by the Postgres Global Development Group.

Table of Contents
1. Introduction
Y2K Statement
Copyrights and Trademarks
2. Ports
Currently Supported Platforms
Unsupported Platforms
3. Configuration Options
Parameters for Configuration (configure)
Parameters for Building (make)
Locale Support
What are the Benefits?
What are the Drawbacks?
Kerberos Authentication
4. System Layout
5. Installation
Requirements to Run Postgres
Installation Procedure
Playing with Postgres
The Next Step
Porting Notes
6. Installation on Win32
Building the libraries
Installing the libraries
Using the libraries
7. Runtime Environment
Using Postgres from Unix
Starting postmaster
Using pg_options
Recognized Options
8. Security
User Authentication
User Names and Groups
Creating Users
Creating Groups
Assigning Users to Groups
Access Control
Functions and Rules
9. Adding and Deleting Users
10. Disk Management
Alternate Locations
11. Managing a Database
Creating a Database
Accessing a Database
Destroying a Database
Backup and Restore
Large Databases
12. Troubleshooting
Postmaster Startup Failures
Client Connection Problems
Debugging Messages
13. Database Recovery
14. Regression Test
Regression Environment
Directory Layout
Regression Test Procedure
Regression Analysis
Error message differences
OID differences
Date and time differences
Floating point differences
Polygon differences
Random differences
The “expected” files
15. Release Notes
Release 6.5.1
Migration to v6.5.1
Detailed Change List
Release 6.5
Migration to v6.5
Detailed Change List
Release 6.4.2
Migration to v6.4.2
Detailed Change List
Release 6.4.1
Migration to v6.4.1
Detailed Change List
Release 6.4
Migration to v6.4
Detailed Change List
Release 6.3.2
Detailed Change List
Release 6.3.1
Detailed Change List
Release 6.3
Migration to v6.3
Detailed Change List
Release 6.2.1
Migration from v6.2 to v6.2.1
Detailed Change List
Release 6.2
Migration from v6.1 to v6.2
Migration from v1.x to v6.2
Detailed Change List
Release 6.1.1
Migration from v6.1 to v6.1.1
Detailed Change List
Release 6.1
Migration to v6.1
Detailed Change List
Release v6.0
Migration from v1.09 to v6.0
Migration from pre-v1.09 to v6.0
Detailed Change List
Release v1.09
Release v1.02
Migration from v1.02 to v1.02.1
Dump/Reload Procedure
Detailed Change List
Release v1.01
Migration from v1.0 to v1.01
Detailed Change List
Release v1.0
Detailed Change List
Postgres95 Beta 0.03
Detailed Change List
Postgres95 Beta 0.02
Detailed Change List
Postgres95 Beta 0.01
Timing Results