Database Administration and Maintenance

From PostgreSQL Wiki

Contents 1 General Admin Topics 2 Backup 3 Authentication 4 Restoration and Recovery 5 Placeholders for topics to cover

General Admin Topics

• Client Authentication (pg_hba.conf)
• Planner Statistics
• Warm Standby
• Replication, Clustering, and Connection Pooling
• Shared Database Hosting

Backup

• Automated Backup on Windows by Tom Hart & Justin

Authentication

• Client Authentication

Restoration and Recovery

• PostgreSQL table checker and dumper tool by Martijn van Oosterhout
• Adventures in PostgreSQL, Episode 1 by Josh Berkus (2002-05)

Placeholders for topics to cover

• Vacuuming
• Monitoring
• Lock Monitoring
• Index Maintenance
• Disk Usage