The project is a continuously updating set of articles, scripts and configuration files made to help with PostgreSQL maintenance. The articles and files might be modified as new versions of software or new ways of doing things appear. Stay tuned.
- Database Server Configuration
- Explaining .psqlrc Startup File
- SSH without Password Setup
- Streaming Replication Setup
- Slony1 Replication Setup
- Switching to Another Server with PgBouncer
- SSH-Tunnel with Compression Setup
- Statement Statistics Collecting and Reporting
- SQL Dumps Management
- PgToolkit - tools for PostgreSQL maintenance
Thank you:
- Nitro Software, Inc. for ideas and code contribution
- PostgreSQL-Consulting.com for lots of testing
- Maxim Boguk for ideas and useful hints