Upgrade and migration#
You can upgrade the Postgres Enterprise Manager (PEM) components including the PEM installation, the backend database, and the SQL Profiler. You can also move the PEM server.
- Upgrading a PEM installation
- PEM upgrade best practices and remediation
- How PEM upgrades preserve permissions
- Dos and don’ts
- Pre-upgrade preparation
- Step 1 — Stop PEM services
- Step 2 — Transfer ownership (only if changing ownership)
- Step 3 — Register default privileges for the upgrade role
- Step 4 — Revoke orphaned defaults from the old role (optional, only if you changed ownership)
- Step 5 — Schema USAGE safety net
- Step 6 — Re-run the verification query and upgrade
- Post-upgrade verification
- Remediation for already-affected clusters
- Example: upgrade with an ownership change
- Upgrading the PEM backend Postgres database
- Adding entries for PEM Agens and admins to connect to PEM server
- Adding entries (localhost) for PEM Agens and admins to connect to PEM server
- Upgrading SQL Profiler
- Upgrading the PEM web server
- Moving the PEM server