PostgreSQL 7.1.2 Administrator's Guide
The PostgreSQL Global Development Group
Copyright
© 1996-2001 by 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 Postgres 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.
Password authentication
4.2.2.
Kerberos authentication
4.2.3.
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 MB
5.2.2.
Setting the Encoding
5.2.3.
Automatic encoding translation between backend and frontend
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.
Alternative Locations
6.2.
Accessing a Database
6.3.
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.
Backup and Restore
8.1.
SQL
Dump
8.1.1.
Restoring the dump
8.1.2.
Using
pg_dumpall
8.1.3.
Large Databases
8.1.4.
Caveats
8.2.
File system level backup
8.3.
Migration between releases
9.
Write-Ahead Logging (
WAL
)
9.1.
General Description
9.1.1.
Immediate Benefits of
WAL
9.1.2.
Future Benefits
9.2.
Implementation
9.2.1.
Database Recovery with
WAL
9.3.
WAL
Configuration
10.
Disk Storage
11.
Database Recovery
12.
Regression Tests
12.1.
Test Evaluation
12.1.1.
Error message differences
12.1.2.
Locale differences
12.1.3.
Date and time differences
12.1.4.
Floating point differences
12.1.5.
Polygon differences
12.1.6.
Tuple ordering differences
12.1.7.
The
"random"
test
12.2.
Platform-specific comparison files
A.
Release Notes
A.1.
Release 7.1.2
A.1.1.
Migration to version 7.1.2
A.1.2.
Changes
A.2.
Release 7.1.1
A.2.1.
Migration to version 7.1.1
A.2.2.
Changes
A.3.
Release 7.1
A.3.1.
Migration to version 7.1
A.3.2.
Changes
A.4.
Release 7.0.3
A.4.1.
Migration to version 7.0.3
A.4.2.
Changes
A.5.
Release 7.0.2
A.5.1.
Migration to version 7.0.2
A.5.2.
Changes
A.6.
Release 7.0.1
A.6.1.
Migration to version 7.0.1
A.6.2.
Changes
A.7.
Release 7.0
A.7.1.
Migration to version 7.0
A.7.2.
Changes
A.8.
Release 6.5.3
A.8.1.
Migration to version 6.5.3
A.8.2.
Changes
A.9.
Release 6.5.2
A.9.1.
Migration to version 6.5.2
A.9.2.
Changes
A.10.
Release 6.5.1
A.10.1.
Migration to version 6.5.1
A.10.2.
Changes
A.11.
Release 6.5
A.11.1.
Migration to version 6.5
A.11.2.
Changes
A.12.
Release 6.4.2
A.12.1.
Migration to version 6.4.2
A.12.2.
Changes
A.13.
Release 6.4.1
A.13.1.
Migration to version 6.4.1
A.13.2.
Changes
A.14.
Release 6.4
A.14.1.
Migration to version 6.4
A.14.2.
Changes
A.15.
Release 6.3.2
A.15.1.
Changes
A.16.
Release 6.3.1
A.16.1.
Changes
A.17.
Release 6.3
A.17.1.
Migration to version 6.3
A.17.2.
Changes
A.18.
Release 6.2.1
A.18.1.
Migration from version 6.2 to version 6.2.1
A.18.2.
Changes
A.19.
Release 6.2
A.19.1.
Migration from version 6.1 to version 6.2
A.19.2.
Migration from version 1.
x
to version 6.2
A.19.3.
Changes
A.20.
Release 6.1.1
A.20.1.
Migration from version 6.1 to version 6.1.1
A.20.2.
Changes
A.21.
Release 6.1
A.21.1.
Migration to version 6.1
A.21.2.
Changes
A.22.
Release 6.0
A.22.1.
Migration from version 1.09 to version 6.0
A.22.2.
Migration from pre-1.09 to version 6.0
A.22.3.
Changes
A.23.
Release 1.09
A.24.
Release 1.02
A.24.1.
Migration from version 1.02 to version 1.02.1
A.24.2.
Dump/Reload Procedure
A.24.3.
Changes
A.25.
Release 1.01
A.25.1.
Migration from version 1.0 to version 1.01
A.25.2.
Changes
A.26.
Release 1.0
A.26.1.
Changes
A.27.
Postgres95
Release 0.03
A.27.1.
Changes
A.28.
Postgres95
Release 0.02
A.28.1.
Changes
A.29.
Postgres95
Release 0.01
A.30.
Timing Results
A.30.1.
Version 6.5
A.30.2.
Version 6.4beta
A.30.3.
Version 6.3
A.30.4.
Version 6.1
List of Tables
3-1.
Short option key
3-2.
System V IPC parameters
5-1.
Postgres
Character Set Encodings
5-2.
Postgres
Client/Server Character Set Encodings
List of Examples
4-1.
An example
pg_hba.conf
file
4-2.
An example
pg_ident.conf
file
Prev
Home
Next
Bibliography
Installation Instructions