Documentation
Prev
Fast Backward
Fast Forward
Next
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.
On-line backup and point-in-time recovery (PITR)
36.4.
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.
Write-Ahead Logging (WAL)
39.1.
Benefits of WAL
39.2.
WAL Configuration
Prev
Home
Next
Usage and Example
Server Run-time Environment