topic Error while trying to ugrade alfresco-5.0.c to alfresco-5.0.d in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-while-trying-to-ugrade-alfresco-5-0-c-to-alfresco-5-0-d/m-p/299409#M252539 <HTML><HEAD></HEAD><BODY><SPAN>when i try to excute this command under /opt/alfresco/postgresql/bin</SPAN><BR /><SPAN> </SPAN><BR /><BR /><SPAN>./dropdb alfresco -h localhost -i</SPAN><BR /><BR /><SPAN>iam facing this error</SPAN><BR /><BR /><SPAN>dropdb.bin: database removal failed: ERROR:&nbsp; database "alfresco" is being accessed by other users</SPAN><BR /><SPAN>DETAIL:&nbsp; There are 11 other sessions using the database.</SPAN><BR /><BR /><SPAN>Please help</SPAN></BODY></HTML> Fri, 28 Aug 2015 08:23:13 GMT raghav_bhardwaj 2015-08-28T08:23:13Z Error while trying to ugrade alfresco-5.0.c to alfresco-5.0.d https://connect.hyland.com/t5/alfresco-archive/error-while-trying-to-ugrade-alfresco-5-0-c-to-alfresco-5-0-d/m-p/299409#M252539 when i try to excute this command under /opt/alfresco/postgresql/bin ./dropdb alfresco -h localhost -iiam facing this errordropdb.bin: database removal failed: ERROR:&nbsp; database "alfresco" is being accessed by other usersDETAIL:&nbsp; There are 11 other sessions using the database.Please help Fri, 28 Aug 2015 08:23:13 GMT https://connect.hyland.com/t5/alfresco-archive/error-while-trying-to-ugrade-alfresco-5-0-c-to-alfresco-5-0-d/m-p/299409#M252539 raghav_bhardwaj 2015-08-28T08:23:13Z Re: Error while trying to ugrade alfresco-5.0.c to alfresco-5.0.d https://connect.hyland.com/t5/alfresco-archive/error-while-trying-to-ugrade-alfresco-5-0-c-to-alfresco-5-0-d/m-p/299410#M252540 <HTML><HEAD></HEAD><BODY><SPAN>I don't know how you are trying to upgrade, but it looks to me like postgres has not been shutdown &amp; retarted on its own. The upgrade process is to shutdown alfresco completely (alfresco.sh stop), start postgres WITHOUT alfresco (I think that is alfresco.sh start postgres - but I am not sure of that). Then drop &amp; restore the DB. Then shutdown postgres and then start alfresco</SPAN></BODY></HTML> Fri, 28 Aug 2015 09:31:13 GMT https://connect.hyland.com/t5/alfresco-archive/error-while-trying-to-ugrade-alfresco-5-0-c-to-alfresco-5-0-d/m-p/299410#M252540 rjohnson 2015-08-28T09:31:13Z