Skip to main content

Maintenance Tasks for PostgreSQL

Monthly Tasks

  • Run VACUUM ANALYZE on large tables: 
    sudo docker exec $NEW_CONTAINER psql -U postgres -d hubble_repository -c "VACUUM ANALYZE VERBOSE;"
  • Review and optimize slow queries
  • Check for unused indexes
  • Review PostgreSQL configuration for optimization opportunities
  • Update statistics targets for frequently queried tables
  • Review SSL certificate expiration dates

Quarterly Tasks

  • Full database VACUUM: 
    sudo docker exec $NEW_CONTAINER psql -U postgres -d hubble_repository -c "VACUUM FULL VERBOSE;"
  • Review and update disaster recovery procedures
  • Test complete backup and restore process
  • Review security settings and access controls
  • Plan for PostgreSQL minor version updates

Appendix A: Verification Checklist

Category Verification Item Expected Result Status
Database PostgreSQL version 15.2
PG_VERSION file 15
All databases present Match 9.5 database list
Table count Match 9.5 table count
Row count Match 9.5 row count
SSL/TLS SSL enabled SHOW ssl; returns "on"
SSL certificates present server.crt, server.key, root.crt exist
Certificate permissions server.key: 400, others: 644
TLS version TLS 1.2 or 1.3
SSL connections working sslmode=require connects successfully
Non-SSL blocked sslmode=disable fails
Configuration postgresql.conf migrated Custom 9.5 settings applied to 15.2
pg_hba.conf configured hostssl entries present
docker-compose.yml updated SSL volume mounts present
Connection string updated SSL Mode=Require;TrustServerCertificate=True
Application Web application loads Homepage accessible
User login works Can authenticate
Queries execute Data retrieval successful
Reports generate Reports complete without errors
Data modification Insert/update/delete work
No errors in logs Application logs clean
Backups /etc/hubble backed up Multiple backup copies exist
Physical data backup tar.gz file created with checksum
SQL dump backup all_databases.sql not empty
SSL certificates backed up Certificate files in backup directory
Config files backed up 9.5 config files preserved
Rollback Original data preserved data_9.5_original_* directory exists
Rollback script created EMERGENCY_ROLLBACK.sh executable
Rollback tested (if possible) Rollback procedure documented

Appendix B: Contact Information for Support

Hubble Support

Support Type Contact Method Details
General Support Support Portal http://central.insightsoftware.com/
Professional Services Email HubbleServices@insightsoftware.com
Product Information Website https://insightsoftware.com/hubble/
Upgrade Assistance Professional Services HubbleServices@insightsoftware.com

Escalation Contacts

For critical production issues during migration:

  • Contact your designated Customer Success Manager
  • Email HubbleServices@insightsoftware.com with "URGENT - Production Migration Issue" in subject line
  • Provide backup directory location and error logs

Was this article helpful?

We're sorry to hear that.