Documentation
 
 
 
PrevFast BackwardFast ForwardNext

VI. Database Server Administration

This part covers topics that are of interest to a EnterpriseDB database administrator.

Table of Contents
30. Server Run-time Environment
30.1. The enterprisedb User Account
30.2. Creating a Database Cluster
30.3. Starting the Database Server
30.4. Run-time Configuration
30.5. Managing Kernel Resources
30.6. Shutting Down the Server
30.7. Secure TCP/IP Connections with SSH Tunnels
31. Database Roles and Privileges
31.1. Database Roles
31.2. Role Attributes
31.3. Privileges
31.4. Role Membership
32. Managing Databases
32.1. Overview
32.2. Creating a Database
32.3. Template Databases
32.4. Database Configuration
32.5. Destroying a Database
32.6. Tablespaces
33. Client Authentication
33.1. The pg_hba.conf file
33.2. Authentication methods
33.3. Authentication problems
34. Localization
34.1. Locale Support
34.2. Character Set Support
35. Routine Database Maintenance Tasks
35.1. Routine Vacuuming
35.2. Routine Reindexing
35.3. Log File Maintenance
36. Backup and Restore
36.1. SQL Dump
36.2. File System Level Backup
36.3. Continuous Archiving and Point-In-Time Recovery (PITR)
36.4. Warm Standby Servers for High Availability
36.5. Migration Between Releases
37. Monitoring Database Activity
37.1. EnterpriseDB DBA Management Server
37.2. The Statistics Collector
37.3. Viewing Locks
38. Monitoring Disk Usage
38.1. Determining Disk Usage
38.2. Disk Full Failure
39. Reliability and the Write-Ahead Log
39.1. Reliability
39.2. Write-Ahead Logging (WAL)
39.3. WAL Configuration
39.4. WAL Internals
40. High Availability and Load Balancing
PrevHomeNext
Usage and Example Server Run-time Environment
 
 ©2004-2007 EnterpriseDB All Rights Reserved