topic Re: Alfresco Community 5.0 -> 5.1 Postgresql Problems release in Alfresco Archive

Alfresco Community 5.0 -> 5.1 Postgresql Problems release

gasp72 — Thu, 17 Mar 2016 18:46:19 GMT

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.4So after the cold restore the database won't start because the data folder is for the older 9.3 v

Re: Alfresco Community 5.0 -> 5.1 Postgresql Problems release

marcio — Fri, 18 Mar 2016 14:39:42 GMT

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

Re: Alfresco Community 5.0 -> 5.1 Postgresql Problems release

bbukvic — Wed, 20 Jul 2016 13:22:58 GMT

I have a same issue. Did you receive any update on your problems described here?