The project is a constantly updated 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:
- PostgreSQL-Consulting.com for lots of testing
- Maxim Boguk for insights, useful hints and supervising