cancel
Showing results for 
Search instead for 
Did you mean: 

Alfresco Community 5.0 -> 5.1 Postgresql Problems release

gasp72
Champ in-the-making
Champ in-the-making
Hi to all,
Following the steps to upgrade from 5.0 to 5.1 I see an error with the postresql database.

The alf_data directory contain a database in postresql 9.3 and the new alfresco have the postgresql 9.4
So after the cold restore the database won't start because the data folder is for the older 9.3 version.
I have tried to use the pg_upgrade script to move the data from the old 9.3 to the new 9.4 format whitout success.
Have someother the same problem?
2 REPLIES 2

marcio
Champ in-the-making
Champ in-the-making
Hello.
You must dump the db in 9.3 and restore at 9.4.

#dumping (old 9.3 server)
#pg_dump -h localhost -U alfresco -Fc -f bkp_alfresco alfresco -w

#restoring (new 9.4 server)
#pg_restore -U postgres -Fc -d alfresco bkp_alfresco

After restore check if the database owner is the user alfresco.
Regards



bbukvic
Champ in-the-making
Champ in-the-making
I have a same issue. Did you receive any update on your problems described here?