cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrading from 5.0.d to 5.1 - PostgreSQL version issue - Solved

maobolgi
Champ in-the-making
Champ in-the-making
I am sorry for the rather silly question, but I am a non technical user who managed to use Alfresco Community Edition from 5.0.b to 5.0.d (including the upgrades and my custom models) for my home environment content management. I always used the installer for both Alfresco and PostgeSQL, for me it is almost an out of the box solution (apart the custom models).

I am currently following the procedure described in the documentation to upgrade to 5.1, but PostgreSQL refuses to start because the "database files are incompatible with server" (see the attached log). I therefore backup up the alfresco 5.0.d DB with the dbdump command and tried to restore it via sql on the 5.1 instance (as advised in some websites), but the result is a bunch of errors and the 5.0.d DB (created by with PostgeSQL 9.3) is neither restored nor upgraded to 9.4.4 (the issue may be that 5.1 already installed its DB). I tried dropping the 5.1 DB, but than restoring complains that no alfresco DB exists.

Due to my reduced knowledge I am totally stuck. Is there anything obvious that I am missing? Or migrating from 5.0.d to 5.1 without proper DB management knowledge is basically impossible?

Thanks

UPDATE: I installed PostgreSQL and managed to back up and restore the Alfresco DB. Thanks to pgAdmin it was actually easier than initially thought.
2 REPLIES 2

bbukvic
Champ in-the-making
Champ in-the-making

Hello

How you solve this issue with Postgresql upgrade for Alfresco?

maobolgi
Champ in-the-making
Champ in-the-making

Hi,

I wrote it at the end of my original post. I simply performed a backup of my original DB (managed by the Alfresco installation) with pgAdmin and restored it in the Postgresql stand alone one.

Cheers,

Maurizio