topic Re: How to rebuild database / recreate alfresco database? in Alfresco Archive

How to rebuild database / recreate alfresco database?

jblank-a — Fri, 15 Aug 2014 07:46:52 GMT

I'm attempting to rebuild the entire 'alfresco' database (on Alfresco Community Edition 4.1) without re-running the installation script. Accordingly, I've dropped all tables within the 'alfresco' database.I restart Tomcat (and thus Alfresco), but the databases are not re-created.Instead, I get outpu

Re: How to rebuild database / recreate alfresco database?

bostaxola — Fri, 15 Aug 2014 09:42:35 GMT

You should crate the databases manually, stop alfresco and tomcat, log in into postgresql and run the following:

CREATE DATABASE alfresco WITH OWNER alfresco;
GRANT ALL PRIVILEGES ON DATABASE alfresco TO alfresco;
‍‍‍

Re: How to rebuild database / recreate alfresco database?

jblank-a — Fri, 15 Aug 2014 14:41:26 GMT

I already did that. Upon startup, Alfresco isn't recreating any of the tables.

Re: How to rebuild database / recreate alfresco database?

bostaxola — Fri, 15 Aug 2014 15:11:00 GMT

I've not found it for your Alfresco version, but you could try the following sql scripts from the 4.0e: http://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/COMMUNITYTAGS/V4.0e/root/projects/repository/config/alfresco/dbscripts/create/org.hibernate.dialect.PostgreSQLDialect/
Once done it, you can upgrade it to the 4.1 comparing 4.0's and 4.1's upgrade dbscript's from the 4.2 http://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/COMMUNITYTAGS/V4.2a/root/projects/repository/config/alfresco/dbscripts/upgrade/

There should be another way, a script that creates again the tables, but since I don't know… Hope you find it helpful.

Re: How to rebuild database / recreate alfresco database?

cver — Wed, 17 Sep 2014 09:25:00 GMT

Hi, since I didn't find any confirmation on the Net, I ask here : do you mean that using only the filesystem (contenstore), the whole database (and not only teh index) can be re-built automatically ? I noticed already that Alfresco writes a huge number of very small files every second, but I couldn't find assurance that a backup of only the filesystem would allow to recover the documents. On the contrary, I found several pages talking about orphans, liabilities between DB and filesystems etc, and that is a bit scary.

Note that I'm using Entreprise 4.0.2.9, not community. But recovery to community would also fit my needs (it's only for severe DR situations)

Re: How to rebuild database / recreate alfresco database?

mrogers — Wed, 17 Sep 2014 09:45:00 GMT

If there's no content store. Then the database is created.

But to the OP. Why are you doing this? If its just a clear out to restore default settings then as well as a drop and recreate of the empty db you also need to delete/remove the content store and index.

Cver, what to backup depends upon your requirements. With PostgreSQL if alfresco is not running then a file system backup should be o.k. If you are using another database or hot backup then you will need the content store and database dump. As per the backup docs.