Tag Archives: postgresql

A new version 1.5 of the A.A.A.R. – Alfresco audit analisys and reporting has been released with a smarter installation wizard and the compliance to the recent Pentaho 5 release (the compliance with Pentaho 4 still remain). This version makes the adoption of A.A.A.R. solution very easy and (quite) ready for the inclusion in the Pentaho marketplace. Stay tuned for new updates!

Imagine to analyze Alfresco data with some real interactive tools, making possible to develop your own free analysis and charts to include in your web pages, presentations or communications to your staff.

No software development, no technical skills required but a really simple user console for a knowledge worker and not a IT professional.

This is what I was thinking while I was developing the AAAR Analytics.

AAAR Analytics will be released soon and I’m going to present it to the next Alfresco Summit in Barcelona. Starting from today I would like to share some videos I have developed, to better understand what the solution is and how easy is to use. With this post I share the very first video and I plan to release one video every couple of days, announced with a twit on @FrkCorti.

If you are interested in Alfresco Audit Analysis and Reporting (A.A.A.R.) and don’t want to waste your (precious) time to understand, install, configure and develop, A.A.A.R. is ready for the Cloud with a full installation on a virtual machine you can download and run without any restriction.

After the high interest of the installation tutorial under Ubuntu plaform, in this post is shared the installation of Alfresco Community 4.2.c on Windows Server 2008 R2 Standard 64bit with Apache Tomcat 7.0.30 and PostgreSQL 9.0.10. The purpose installation is not the bundle installation but a more “robust” for an enterprise configuration. As we like and prefer the installation is a step by step list of commands and tasks… simpler to understand, to do and to test. Hope you’ll be agree.

Before starting…

In this tutorial I use a brand new Windows Server 2008 R2 Standard 64bit installation with a user called ‘alfresco’, different from the Administrator user. Connected as ‘alfresco’ user:

In the Alfresco wiki is described the backup and restore strategy but is not so clear how to do it in detail. In this post is shared a practical way to perform a restore of a backuped Alfresco in the way I like: a list of commands and tasks to execute… simpler to understand, to do and to test.

In this example is supposed that Alfresco is installed in ‘/opt/alfresco’ folder and the DBMS used is PostgreSQL. The restore strategy supposes that the backup is done as a “cold backup” described in this ‘Alfresco backup script‘ post.

Let’s start…

First of all proceed to stop alfresco.

service alfresco stop

Supposing the DBMS runs using the ‘postgres’ user, proceed as first task to restore the PostgreSQL database.

Digit CTRL+d to exit from the shell. Supposing the DBMS backup is stored in the ‘alfresco_postgres.tar’ file conforming to the backup strategy described here, let’s go ahead with the restoring of the database.

pg_restore -d alfresco alfresco_postgres.tar
exit

Now it’s time to restore the ‘alf_data’ folder with documents and indexes. Also in this case is supposed that the files are stored in a ‘alfresco_data.tgz’ file conforming to the backup strategy described here.

cd /opt/alfresco
mv alf_data alf_data.old
tar zxvf alfresco_data.tgz

That’s all!
Now it’s time to start again Alfresco and use it normally.