Migration Guides
This directory contains comprehensive migration guides for the Industry Core Hub application.
Available Guides
Purpose: Concise step-by-step guide for migrating from Bitnami PostgreSQL 15 to CloudPirates PostgreSQL 18.0
When to use this guide:
- You need a quick reference during migration
- You want clear, actionable commands
- You’re migrating the Industry Core Hub database
Features:
- 7 simple steps with commands
- 15-60 minute estimated timeline
- Quick rollback procedure
Target Audience: Anyone performing the PostgreSQL migration for Industry Core Hub
Migration Strategy Overview
All guides in this directory follow a similar strategy:
- Pre-Migration
- Verify current state
- Document existing data (business_partner, twin tables, etc.)
- Create comprehensive backup using
pg_dumpall
- Migration
- Stop current deployment
- Delete only PostgreSQL PVC (backend PVCs preserved)
- Update Chart.yaml and values.yaml
- Deploy CloudPirates PostgreSQL 18
- Restore data from backup
- Verification
- Verify PostgreSQL 18 version
- Verify data integrity in
ichub-postgres database
- Test application and connectivity
- Verify backend PVCs remain bound
- Post-Migration
- Monitor application logs
- Verify backend functionality
- Archive backups
Important Notes
- Database Name: Industry Core Hub uses
ichub-postgres as the database name
- PVC Strategy: Only the PostgreSQL PVC is migrated; backend data and logs PVCs are preserved
- Tables: Main tables include
business_partner, twin, catalog_part, batch, etc.
- Pod Name: PostgreSQL pod is named
industry-core-hub-postgresql-0
NOTICE
This work is licensed under the CC-BY-4.0.