The project is a constantly updating set of articles, scripts and configuration files to help maintain PostgreSQL. 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
- PgToolkit - tools for PostgreSQL maintenance
Thank you:
- PostgreSQL-Consulting.com for lots of testing
- Maxim Boguk for insights, useful hints and supervising