PostgreSQL 7.3.4 Administrator's Guide
PostgreSQL 7.3.4 Administrator's Guide
The PostgreSQL Global Development Group
Copyright © 1996-2002 The PostgreSQL Global Development Group
- Table of Contents
- Preface
- 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 Run-time 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. pg_settings
- 3.4.2. Planner and Optimizer Tuning
- 3.4.3. Logging and Debugging
- 3.4.4. General Operation
- 3.4.5. WAL
- 3.4.6. 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. Database Users and Privileges
- 4.1. Database Users
- 4.2. User Attributes
- 4.3. Groups
- 4.4. Privileges
- 4.5. Functions and Triggers
- 5. Managing Databases
- 5.1. Overview
- 5.2. Creating a Database
- 5.3. Template Databases
- 5.4. Database Configuration
- 5.5. Alternative Locations
- 5.6. Destroying a Database
- 6. Client Authentication
- 6.1. The pg_hba.conf file
- 6.2. Authentication methods
- 6.2.1. Trust authentication
- 6.2.2. Password authentication
- 6.2.3. Kerberos authentication
- 6.2.4. Ident-based authentication
- 6.2.5. PAM Authentication
- 6.3. Authentication problems
- 7. Localization
- 7.1. Locale Support
- 7.2. Multibyte Support
- 7.2.1. Supported character set encodings
- 7.2.2. Setting the Encoding
- 7.2.3. Automatic encoding conversion between server and client
- 7.2.4. What happens if the translation is not possible?
- 7.2.5. References
- 7.2.6. History
- 7.2.7. WIN1250 on Windows/ODBC
- 7.3. Single-byte character set recoding
- 8. Routine Database Maintenance Tasks
- 9. Backup and Restore
- 9.1. SQL Dump
- 9.1.1. Restoring the dump
- 9.1.2. Using pg_dumpall
- 9.1.3. Large Databases
- 9.1.4. Caveats
- 9.2. File system level backup
- 9.3. Migration between releases
- 10. Monitoring Database Activity
- 10.1. Standard Unix Tools
- 10.2. Statistics Collector
- 10.2.1. Statistics Collection Configuration
- 10.2.2. Viewing Collected Statistics
- 10.3. Viewing Locks
- 11. Monitoring Disk Usage
- 11.1. Determining Disk Usage
- 11.2. Disk Full Failure
- 12. Write-Ahead Logging (WAL)
- 12.1. General Description
- 12.1.1. Immediate Benefits of WAL
- 12.1.2. Future Benefits
- 12.2. Implementation
- 12.2.1. Database Recovery with WAL
- 12.3. WAL Configuration
- 13. Regression Tests
- 13.1. Introduction
- 13.2. Running the Tests
- 13.3. Test Evaluation
- 13.3.1. Error message differences
- 13.3.2. Locale differences
- 13.3.3. Date and time differences
- 13.3.4. Floating-point differences
- 13.3.5. Polygon differences
- 13.3.6. Row ordering differences
- 13.3.7. The "random" test
- 13.4. Platform-specific comparison files
- A. Release Notes
- A.1. Release 7.3.4
- A.1.1. Migration to version 7.3.4
- A.1.2. Changes
- A.2. Release 7.3.3
- A.2.1. Migration to version 7.3.3
- A.2.2. Changes
- A.3. Release 7.3.2
- A.3.1. Migration to version 7.3.2
- A.3.2. Changes
- A.4. Release 7.3.1
- A.4.1. Migration to version 7.3.1
- A.4.2. Changes
- A.5. Release 7.3
- A.5.1. Overview
- A.5.2. Migration to version 7.3
- A.5.3. Changes
- A.6. Release 7.2.4
- A.6.1. Migration to version 7.2.4
- A.6.2. Changes
- A.7. Release 7.2.3
- A.7.1. Migration to version 7.2.3
- A.7.2. Changes
- A.8. Release 7.2.2
- A.8.1. Migration to version 7.2.2
- A.8.2. Changes
- A.9. Release 7.2.1
- A.9.1. Migration to version 7.2.1
- A.9.2. Changes
- A.10. Release 7.2
- A.10.1. Overview
- A.10.2. Migration to version 7.2
- A.10.3. Changes
- A.11. Release 7.1.3
- A.11.1. Migration to version 7.1.3
- A.11.2. Changes
- A.12. Release 7.1.2
- A.12.1. Migration to version 7.1.2
- A.12.2. Changes
- A.13. Release 7.1.1
- A.13.1. Migration to version 7.1.1
- A.13.2. Changes
- A.14. Release 7.1
- A.14.1. Migration to version 7.1
- A.14.2. Changes
- A.15. Release 7.0.3
- A.15.1. Migration to version 7.0.3
- A.15.2. Changes
- A.16. Release 7.0.2
- A.16.1. Migration to version 7.0.2
- A.16.2. Changes
- A.17. Release 7.0.1
- A.17.1. Migration to version 7.0.1
- A.17.2. Changes
- A.18. Release 7.0
- A.18.1. Migration to version 7.0
- A.18.2. Changes
- A.19. Release 6.5.3
- A.19.1. Migration to version 6.5.3
- A.19.2. Changes
- A.20. Release 6.5.2
- A.20.1. Migration to version 6.5.2
- A.20.2. Changes
- A.21. Release 6.5.1
- A.21.1. Migration to version 6.5.1
- A.21.2. Changes
- A.22. Release 6.5
- A.22.1. Migration to version 6.5
- A.22.2. Changes
- A.23. Release 6.4.2
- A.23.1. Migration to version 6.4.2
- A.23.2. Changes
- A.24. Release 6.4.1
- A.24.1. Migration to version 6.4.1
- A.24.2. Changes
- A.25. Release 6.4
- A.25.1. Migration to version 6.4
- A.25.2. Changes
- A.26. Release 6.3.2
- A.26.1. Changes
- A.27. Release 6.3.1
- A.27.1. Changes
- A.28. Release 6.3
- A.28.1. Migration to version 6.3
- A.28.2. Changes
- A.29. Release 6.2.1
- A.29.1. Migration from version 6.2 to version 6.2.1
- A.29.2. Changes
- A.30. Release 6.2
- A.30.1. Migration from version 6.1 to version 6.2
- A.30.2. Migration from version 1.x to version 6.2
- A.30.3. Changes
- A.31. Release 6.1.1
- A.31.1. Migration from version 6.1 to version 6.1.1
- A.31.2. Changes
- A.32. Release 6.1
- A.32.1. Migration to version 6.1
- A.32.2. Changes
- A.33. Release 6.0
- A.33.1. Migration from version 1.09 to version 6.0
- A.33.2. Migration from pre-1.09 to version 6.0
- A.33.3. Changes
- A.34. Release 1.09
- A.35. Release 1.02
- A.35.1. Migration from version 1.02 to version 1.02.1
- A.35.2. Dump/Reload Procedure
- A.35.3. Changes
- A.36. Release 1.01
- A.36.1. Migration from version 1.0 to version 1.01
- A.36.2. Changes
- A.37. Release 1.0
- A.37.1. Changes
- A.38. Postgres95 Release 0.03
- A.38.1. Changes
- A.39. Postgres95 Release 0.02
- A.39.1. Changes
- A.40. Postgres95 Release 0.01
- List of Tables
- 3-1. pg_settings Columns
- 3-2. Short option key
- 3-3. System V IPC parameters
- 7-1. Character Set Encodings
- 7-2. Client/Server Character Set Encodings
- 10-1. Standard Statistics Views
- 10-2. Statistics Access Functions
- 10-3. Lock Status System View
- List of Examples
- 6-1. An example pg_hba.conf file
- 6-2. An example pg_ident.conf file