How to migrate the Spectrum Report Manager (SRM) Jasper jasperserver-pro postgres database from one system to another.

Products

• CA Spectrum

Issue/Introduction

How to migrate the Spectrum Report Manager (SRM) Jasper jasperserver-pro postgres database from one system to another.

For example, I have Jasper 6.4.3 installed on Linux 6. I have new Linux 7 systems and will install Jasper 6.4.3 new on the new Linux 7 system. How do I migrate the Jasper 6.4.3 jasperserver-pro postgres database from the Linux 6 system to the Linux 7 system?

Environment

Release : Any

Component : Spectrum Reporting / Jasper

Resolution

You can use the pg_dump command to create a backup of the postgres database and then use the pg_restore command to load it.

Additional Information

Please reference the following links for additional information:

https://community.jaspersoft.com/blog/tip-take-backup-postgresql-database-command-prompt-postgeres-jasperserver-installed-cent-os-65

Backing Up Databases Using PostgreSQL Backup Tools

PostgreSQL Restore Database