Error while trying to ugrade alfresco-5.0.c to alfresco-5.0.d

[raghav_bhardwaj]

when i try to excute this command under /opt/alfresco/postgresql/bin


./dropdb alfresco -h localhost -i

iam facing this error

dropdb.bin: database removal failed: ERROR:  database "alfresco" is being accessed by other users
DETAIL:  There are 11 other sessions using the database.

Please help

[rjohnson]

I don't know how you are trying to upgrade, but it looks to me like postgres has not been shutdown & 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 & restore the DB. Then shutdown postgres and then start alfresco