PrevFast BackwardFast ForwardNext

VI. Database Server Administration

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

Table of Contents
21. Server Run-time Environment
21.1. The enterprisedb User Account
21.2. Creating a Database Cluster
21.3. Starting the Database Server
21.4. Run-time Configuration
21.5. Managing Kernel Resources
21.6. Shutting Down the Server
21.7. Secure TCP/IP Connections with SSH Tunnels
22. Database Users and Privileges
22.1. Database Users
22.2. User Attributes
22.3. Groups
22.4. Privileges
23. Managing Databases
23.1. Overview
23.2. Creating a Database
23.3. Template Databases
23.4. Database Configuration
23.5. Destroying a Database
23.6. Tablespaces
24. Client Authentication
24.1. The pg_hba.conf file
24.2. Authentication methods
24.3. Authentication problems
25. Localization
25.1. Locale Support
25.2. Character Set Support
26. Routine Database Maintenance Tasks
26.1. Routine Vacuuming
26.2. Routine Reindexing
26.3. Log File Maintenance
27. Backup and Restore
27.1. SQL Dump
27.2. File system level backup
27.3. On-line backup and point-in-time recovery (PITR)
28. Monitoring Database Activity
28.1. Standard Unix Tools
28.2. The Statistics Collector
28.3. Viewing Locks
29. Monitoring Disk Usage
29.1. Determining Disk Usage
29.2. Disk Full Failure
30. Write-Ahead Logging (WAL)
30.1. Benefits of WAL
30.2. WAL Configuration
30.3. Internals
PrevHomeNext
Python Server Run-time Environment