powered by Jive Software

Manual database upgrade

Hi, it appears that I partly messed up an upgrade from 2.4.4 to 2.6.2. It mostly works but it appears that the database didn’‘t get upgraded. We’‘re using Postgresql and when I look at the jiveversion table, it reports version 2.2, so I think we’'re a little behind.

So, now the question is how do I manually upgrade the database to where it should be? I see there’‘s a several upgrade scripts in the /opt/wildfire/resources/database/upgrade directory, each in a directory numbered 1-8 but I’'m not sure which one to use and what the proper procedure to do so is.

Any help would be appreciated.

Hi,

JIVEVERSION should contain something like

wildfire, 5

So you would be running version 5 and you would need to run the scripts in directories /6, /7 and /8.

Each script contains somewhere at the end (eg for upgrade/6/wildfire_db.sql):

INSERT INTO jiveVersion (name, version) VALUES (’‘wildfire’’, 6);

So you should run script after the other and probably add a

commit;

if your db session does not use auto-commit.

LG