Steps to upgrade PBS datastore when postgresql is upgraded

PP-756 - Getting issue details... STATUS

forum discussion.

How to upgrade PBS datastore when PostgreSQL is upgraded.

If PostgreSQL is upgraded, PBS datastore would also need to be upgraded for PBS to work without errors. PBS datastore upgrades are tested to work well when the upgrades are performed using the pg_upgrade tool provided by PostgreSQL that allows database updates between major versions without data dump/reload.

While the steps needed for an upgrade using pg_upgrade do not change, it is advisable to consult the documentation for the newer version of PostgreSQL before performing the upgrade.

Points to remember while upgrading PBS database -

1) PBS datastore location - $PBS_HOME/datastore

2) default port used by PBS dataservice – 15007

3) Once the upgrade is successful, use pbs_ds_password to reset the PBS data user password.

As an example, logs from a database upgrade session is attached to this page.

Disclaimer:

The logs in the example provided are for the postresql upgrade from 9.2 to 9.3 on a centos7 machine. It can be used only as a reference and there is no guarantee that exact steps will work in a similar configuration.