Checklist for PostgreSQL release ================================ Date: _______________________ Version: _______________________ Tester: _______________________ System: _______________________ Installation ------------ - New installation passed without suspicious messages on a clean base system? [ ] - Update installation on top of an existing 8.1 database server without errors? [ ] - Is old data migrated completely when update has finished? [ ] - Update installation on top of an existing 8.2 database server without errors? [ ] - Is old data migrated completely when update has finished? [ ] - Does reinstallation work without loss of data or config values?[ ] Deinstallation -------------- - Any error message? [ ] - Has every package file been removed upon uninstall? [ ] Configuration ------------- - Are default settings useable / reasonable? [ ] - Does server run with acceptable performance with default settings? [ ] - All values are editable and refuse false settings [ ] - Does the server run even if settings are senseless / extreme? [ ] - Every setting has an associated ece help entry [ ] Documentation ------------- - Documentation complete, up to date and understandable? [ ] - Are there any non ASCII characters within documentation files? [ ] - Do index-positions of doc-viewer match the headlines? [ ] - Are dates and version info headers up to date? [ ] Server-Management ----------------- - Do server scripts work as expected? [ ] - Is server handable even if START_POSTGRESQL is set to "no"? [ ] Administration -------------- - Is administration tool executable? [ ] - Can postgres user log in without password? [ ] - Does administartion tool work in remote mode and is able to connect to localhost? [ ] - Are help entries of all items available? [ ] - Creation, modification and deletion of databases [ ] - Creation, modification and deletion of login roles [ ] - Creation, modification and deletion of group roles [ ] - Assignment and unassignment of parent roles [ ] - Installation, check and uninstallation of PL/pgSQL [ ] - Installation, check and uninstallation of tsearch2 [ ] - Installation, check and uninstallation of pgAdmin [ ] - Backup of databases inside admin tool [ ] - Restore of databases inside admin tool [ ] - Backup of databases from menu item [ ] - Restore of databases from menu item [ ] - List of backup files from menu item [ ] - Automatic (cron-controled) backup [ ] - Launch and connect to database with SQL interpreter [ ] Security -------- - Setting local password and admin password [ ] - Does admin tool still connect? [ ] - Does SQL console still connect? [ ] - Does backup and restore still work? [ ] Additional tests ---------------- - Does pam authentication work (read documentation)? [ ]