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
Summary
1.
Introduction
Resources
Terminology
Notation
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
Availability
Installation
Operation
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
Functions
Rules
Caveats
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
pg_options
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
v6.5
v6.4beta
v6.3
v6.1
Bibliography
Next
Summary